select vip,
    count(u.user_id) as visit_nums,
    count(distinct u.user_id) as visit_users
from visit_tb v
left join uservip_tb u
    using(user_id)
group by vip
order by visit_nums desc