select t1.user_id,count(*) visit_nums
from (select distinct user_id,date_format(order_time,'%Y-%m-%d') order_time from order_tb)t1 join visit_tb t2 on (t1.user_id = t2.user_id)
where date_format(order_time,'%Y-%m-%d') = '2022-09-02' and date_format(visit_time,'%Y-%m-%d') = '2022-09-02' and date_format(leave_time,'%Y-%m-%d') = '2022-09-02'
group by t1.user_id 
order by visit_nums desc