select u.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

题目应该去掉每日