I have two tables members and ads, members table has auto_increment 'ID' , 'CREDIT' and some members information.
ads table has 'AID' auto_increment and 'ID' to track who's link is that
Basically 1 member can have up to 5 link ads. I want to get from query LIMIT 5 ads who has enough credits and not from same members ID
I'm using php have 4000 members row and growing
how can i design it