mysql 一列转多行写法

mysql一列转多行写法:
SELECT
    a.id,
    SUBSTRING_INDEX(
        SUBSTRING_INDEX(
            a.zxzj_ids,
            ',',
            b.help_topic_id + 1
        ),
        ',' ,- 1
    ) zxzj_id
FROM
     c_dis_group a
JOIN mysql.help_topic b ON b.help_topic_id < (LENGTH(a.zxzj_ids) - LENGTH(REPLACE(a.zxzj_ids, ',', '')) + 1)