SELECT DATE_SUB(curdate(),INTERVAL WEEKDAY(curdate()) DAY) as createtime <!-- 获取本周一的日期 -->
union all
SELECT DATE_ADD(DATE_SUB(curdate(),INTERVAL WEEKDAY(curdate()) DAY),INTERVAL 1 DAY) <!-- 本周二 逻辑为本周一的后一天 -->
union all
SELECT DATE_ADD(DATE_SUB(curdate(),INTERVAL WEEKDAY(curdate()) DAY),INTERVAL 2 DAY) <!-- 本周三 逻辑为本周一的后二天 -->
union all
SELECT DATE_ADD(DATE_SUB(curdate(),INTERVAL WEEKDAY(curdate()) DAY),INTERVAL 3 DAY) <!-- 本周四 逻辑为本周一的后三天 -->
union all
SELECT DATE_ADD(DATE_SUB(curdate(),INTERVAL WEEKDAY(curdate()) DAY),INTERVAL 4 DAY) <!-- 本周五 逻辑为本周一的后四天 -->
union all
SELECT DATE_ADD(DATE_SUB(curdate(),INTERVAL WEEKDAY(curdate()) DAY),INTERVAL 5 DAY) <!-- 本周六 逻辑为本周一的后五天 -->
union all
SELECT DATE_ADD(DATE_SUB(curdate(),INTERVAL WEEKDAY(curdate()) DAY),INTERVAL 6 DAY) <!-- 本周日 逻辑为本周一的后六天 -->