获取日期序列

SELECT
(@num:=@num + 1) AS num,SUBDATE(SUBDATE(CURDATE(),INTERVAL 1 DAY), INTERVAL @num-1 DAY) date
FROM
z_user,(SELECT @num:=0) AS t