select
        utb.vip,
        count(vtb.user_id) as visit_nums,
        count(distinct vtb.user_id) as visit_users
from 
        visit_tb as vtb
left join 
        uservip_tb as utb
on 
        vtb.user_id = utb.user_id
group by 
        utb.vip
order by 
        visit_nums desc