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