grafana中下拉框中展示最近日期

WITH RECURSIVE date_series AS (
    -- 初始值：今天
    SELECT DATE_FORMAT(NOW(), '%Y-%m-%d') AS `datetime`
    
    UNION ALL
    
    -- 递归：每次减 1 天，直到 60 天前
    SELECT DATE_FORMAT(SUBDATE(`datetime`, INTERVAL 1 DAY), '%Y-%m-%d')
    FROM date_series
    WHERE `datetime` > DATE_FORMAT(SUBDATE(NOW(), INTERVAL 60 DAY), '%Y-%m-%d')
)
SELECT `datetime` FROM date_series
ORDER BY `datetime` DESC;