例如，我的dB database data中有以下数据
并且我希望对按月份分组的条目进行计数。此外，我希望对DB中不存在的月份显示计数0。
下面是我使用Codeigniter编写的代码片段：

$result = $builder->select('COUNT(insta_alert_id), MONTH(created_at)')
            ->where("created_at BETWEEN '2022-04-01' AND '2023-07-31'")
            ->where('school_id', $loginDt['school_id'])
            ->groupBy('YEAR(created_at)')
            ->groupBy('MONTH(created_at)')
            ->get()
            ->getResultArray();

        $data = array();

        if (!empty($result)) {
            $rowDt = array();
            foreach ($result as $dt) {
                $rowDt['count'] = $dt['COUNT(insta_alert_id)'];
                $rowDt['month'] = $dt['MONTH(created_at)'];
                $data[] = $rowDt;
            }
        }

我在Postman中得到如下结果：

"data": [
    {
        "count": "11",
        "month": "4"
    },
    {
        "count": "6",
        "month": "5"
    },
    {
        "count": "1",
        "month": "6"
    }
]

而我想要的是：

"data": [
        {
            "count": "0",
            "month": "1",
        },
        {   "count": "0",
            "month": "2"
        },
        {
            "count": "0",
            "month": "3"
        {
            "count": "11",
            "month": "4"
        },
        {
            "count": "6",
            "month": "5"
        },
        {
            "count": "1",
            "month": "6"
        }
        .
        .
        .
    ]