select distinct vip 
,sum(用户visit_nums) visit_nums
,count(user_id)  visit_users
from 
(
	select vip
	,visit_tb.user_id
	,count(visit_time) 用户visit_nums
	from visit_tb
	join uservip_tb
	on visit_tb.user_id = uservip_tb.user_id
	group by 1,2
) a 
group by 1
order by visit_nums desc,visit_users desc