I want to create a monthly payment system for community members, at this point I have figured out that I need the following tables in my mysql database.

Edited

1. Users table

   user_id, first_name, last_name
   

2. Payment table

   payment_id,user_id,amount,due_date,payment_date,total
   

What I need to display list of users who did not pay 6th of every month.

How do I do this? And once the last day of the month is reached, how do I move to the next month?