select t1.vip
,count(*) as visit_nums
,count(distinct t.user_id) as visit_users
from visit_tb t
join uservip_tb t1 on t.user_id=t1.user_id
group by t1.vip
order by visit_nums desc