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