select
u.vip vip
,count(*) visit_nums
,count(distinct v.user_id) visit_users
from visit_tb v
inner join uservip_tb u
on v.user_id = u.user_id
group by u.vip
order by visit_nums desc