SELECT  t1.dateTime as name, IFNULL(t2.count, 0) as count
        FROM (SELECT RIGHT(date_add(DATE_SUB('2024-05-01', INTERVAL 1 DAY), INTERVAL
                                    (cast(help_topic_id AS signed INTEGER) + 1) DAY), 5) dateTime
              FROM mysql.help_topic
              WHERE help_topic_id < DATEDIFF('2024-05-31',
                                                date_sub('2024-05-01', INTERVAL 1 DAY))) t1
                 LEFT JOIN (SELECT date_format(td.replace_date, '%m-%d') AS month, count(1) as count
                            FROM test td
                            WHERE  td.deleted=0 AND td.replace_date BETWEEN '2024-05-01 00:00:00' AND '2024-05-31 23:59:59' 
                            group by date_format(td.replace_date, '%m-%d')) t2 ON t1.dateTime = t2.month

        ORDER BY t1.dateTime asc