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

可以先看一下表连接后的表格，只要统计去重visit_time即可,count(distinct v.visit_time)as visit_nums