select vip,
count(1) as visit_nums,
count(distinct a.user_id) as visit_users
from visit_tb a join uservip_tb b on a.user_id=b.user_id
group by vip
order by visit_nums desc