select b.username from a left join b on a.id=b.recommend_id select a.username,count(a.id) from a group by a.recommend_id