SELECT o.user_id,COUNT(DISTINCT v.visit_time) AS visit_nums

FROM order_tb AS o 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