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