select 
t2.vip
,count(t1.user_id) visit_nums
,count(distinct t1.user_id) visit_users
from visit_tb t1
join uservip_tb t2
on t1.user_id = t2.user_id
group by 1
order by 2 desc