select 
    u.vip as vip, 
    count(v.user_id) 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
#按照会员等级分组，计算会员人数