SELECT

    vt.user_id,

    COUNT(leave_time) AS visit_nums

FROM visit_tb vt

JOIN(

    SELECT

        DISTINCT user_id AS user_id,

        DATE(order_time) AS order_date

    FROM order_tb

    WHERE DATE(order_time) = '2022-09-02'

) AS tb1

ON vt.user_id = tb1.user_id

WHERE DATE(leave_time) = '2022-09-02'

GROUP BY vt.user_id

ORDER BY visit_nums DESC