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