mysql 按每月自定天数统计数据

表结构
查询一个月内每五天的总数

SELECT
COUNT(wc.`id`) AS countNumber,wc.`createdDate`
FROM
wechatuser wc
WHERE DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= DATE(wc.`createdDate`) GROUP BY (
        YEAR(wc.`createdDate`)* 1000 + (DAYOFYEAR(wc.`createdDate`)-MOD(DAYOFYEAR(CURDATE()),5)) DIV 5
    );