SELECT vip, count(*) as visit_nums, count(distinct user_id) as visit_users
from visit_tb
JOIN uservip_tb
USING(user_id)
GROUP BY vip
order by visit_nums DESC,visit_users DESC