select
    a.user_id,
    count(a.user_id) as visit_nums
from
    visit_tb as a
where
    a.user_id in (
        select distinct
            b.user_id
        from
            order_tb as b
        where
            date (b.order_time) = '2022-09-02'
    )
    and date (a.visit_time) = '2022-09-02'
group by
    a.user_id
order by
    visit_nums desc;