SELECT DATE_FORMAT(`DATE`, '%b %Y') AS Month
, CONVERT(GROUP_CONCAT(DAY(`DATE`)) USING utf8 ) AS Dates
FROM `tablea`
GROUP BY Month
หรือ
Code (PHP)
SELECT DATE_FORMAT(`DATE`, '%b %Y') AS Month
, CAST(GROUP_CONCAT(DAY(`DATE`)) AS CHAR(10000) CHARACTER SET utf8 ) AS Dates
FROM `tablea`
GROUP BY Month