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