SELECT
    ut.vip,
    COUNT(user_id) AS visit_nums,
    COUNT(DISTINCT user_id) AS visit_users
FROM visit_tb vt
JOIN uservip_tb ut USING (user_id)
GROUP BY vip
ORDER BY visit_nums DESC