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