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

记得检查desc升降排序有没有写