mysql查询连续时间间隔

WITH RankedOrders AS (
    SELECT
        user_id,
        order_date,
        ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY order_date) AS rn
    FROM orders
)
SELECT DISTINCT user_id
FROM RankedOrders ro1
JOIN RankedOrders ro2 ON ro1.user_id = ro2.user_id AND ro1.rn = ro2.rn - 1
JOIN RankedOrders ro3 ON ro1.user_id = ro3.user_id AND ro1.rn = ro3.rn - 2
JOIN RankedOrders ro4 ON ro1.user_id = ro4.user_id AND ro1.rn = ro4.rn - 3
JOIN RankedOrders ro5 ON ro1.user_id = ro5.user_id AND ro1.rn = ro5.rn - 4
JOIN RankedOrders ro6 ON ro1.user_id = ro6.user_id AND ro1.rn = ro6.rn - 5
JOIN RankedOrders ro7 ON ro1.user_id = ro7.user_id AND ro1.rn = ro7.rn - 6
WHERE DATEDIFF(ro2.order_date, ro1.order_date) = 1
  AND DATEDIFF(ro3.order_date, ro2.order_date) = 1
  AND DATEDIFF(ro4.order_date, ro3.order_date) = 1
  AND DATEDIFF(ro5.order_date, ro4.order_date) = 1
  AND DATEDIFF(ro6.order_date, ro5.order_date) = 1
  AND DATEDIFF(ro7.order_date, ro6.order_date) = 1;