select
    vip,
    count(vt.user_id) visit_nums,
    count(distinct vt.user_id) visit_users
from
    uservip_tb ut
    left join visit_tb vt on ut.user_id = vt.user_id
group by
    vip
order by
    visit_nums desc