select vip , count(1) as visit_nums , count(distinct t1.user_id) as visit_users
from (
select user_id , substr(visit_time , 1,10) as dt
from visit_tb 
--group by user_id ,substr(visit_time , 1,10)
 ) t1
inner join uservip_tb t2 on t1.user_id = t2.user_id
group by vip
order by 2 desc

同一人每日访问两次也需要统计两次