如何在存储过程中按逗号分隔的id对多条记录进行分组？

CREATE PROCEDURE group_records_by_ids(ids_str VARCHAR(255))
BEGIN
    DECLARE ids VARCHAR(255);
    SET ids = ids_str;

    -- 创建临时表，存储拆分后的id
    CREATE TEMPORARY TABLE temp_ids (
        id INT
    );

    -- 拆分id字符串，并插入临时表
    WHILE LENGTH(ids) > 0 DO
        SET @id = SUBSTRING_INDEX(ids, ',', 1);
        SET ids = SUBSTRING(ids, LENGTH(@id) + 2);
        INSERT INTO temp_ids (id) VALUES (CAST(@id AS UNSIGNED));
    END WHILE;

    -- 按拆分后的id进行分组
    SELECT id, COUNT(*) AS record_count
    FROM temp_ids
    GROUP BY id;

    -- 删除临时表
    DROP TEMPORARY TABLE IF EXISTS temp_ids;
END

CALL group_records_by_ids('1,2,3,1,2,4');