mysql 查询显示 时间段每天 时间列表

CREATE TABLE `num` (
  `i` INT(11) NOT NULL
) ENGINE=INNODB DEFAULT CHARSET=utf8;
INSERT INTO `num` VALUES ('1');
INSERT INTO `num` VALUES ('2');
INSERT INTO `num` VALUES ('3');
INSERT INTO `num` VALUES ('4');
INSERT INTO `num` VALUES ('5');
INSERT INTO `num` VALUES ('6');
INSERT INTO `num` VALUES ('7');
INSERT INTO `num` VALUES ('8');
INSERT INTO `num` VALUES ('9');
INSERT INTO `num` VALUES ('10');
INSERT INTO `num` VALUES ('11');
INSERT INTO `num` VALUES ('12');
INSERT INTO `num` VALUES ('13');
INSERT INTO `num` VALUES ('14');
INSERT INTO `num` VALUES ('15');
INSERT INTO `num` VALUES ('16');
INSERT INTO `num` VALUES ('17');
INSERT INTO `num` VALUES ('18');
INSERT INTO `num` VALUES ('19');
INSERT INTO `num` VALUES ('20');
INSERT INTO `num` VALUES ('21');
INSERT INTO `num` VALUES ('22');
INSERT INTO `num` VALUES ('23');
INSERT INTO `num` VALUES ('24');
INSERT INTO `num` VALUES ('25');
INSERT INTO `num` VALUES ('26');
INSERT INTO `num` VALUES ('27');
INSERT INTO `num` VALUES ('28');
INSERT INTO `num` VALUES ('29');
INSERT INTO `num` VALUES ('30');
INSERT INTO `num` VALUES ('31');


SELECT DATE_FORMAT(ADDDATE('2018-05-01', INTERVAL i DAY),'%Y-%m-%d') AS DATE
FROM num WHERE ADDDATE('2018-05-01', INTERVAL i DAY) <= DATE_FORMAT(CURDATE(),'%Y-%m-%d')

ORDER BY DATE;