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