Show Count of zero for missing user list

i have a table of purchases.  I have a separate list of user names.  I want to show that my list of user names has never made an purchase (ie. there are zero entries in the purchase table for the given users.)

What is the best way to go about this?

Thanks so much!