SELECT

    u.vip,

    COUNT(info_id) AS visit_nums,

    COUNT(DISTINCT v.user_id) AS visit_users

FROM

    visit_tb AS v

    JOIN uservip_tb AS u ON v.user_id = u.user_id

GROUP BY

    u.vip

ORDER BY

    visit_nums DESC