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