SELECT t2.vip,
       COUNT(t1.user_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 t2.vip
ORDER BY visit_nums DESC