mysql 按字段分隔符分成多行

SELECT a.id,SUBSTRING_INDEX(SUBSTRING_INDEX(a.continuity_classid,',',b.help_topic_id+1),',',-1) 
FROM 
education.classes_base a
JOIN
mysql.help_topic b
ON b.help_topic_id < (LENGTH(a.continuity_classid) - LENGTH(REPLACE(a.continuity_classid,',',''))+1)
ORDER BY a.id;

-----------------

SELECT a.id purpose_class_id,SUBSTRING_INDEX(SUBSTRING_INDEX(a.continuity_classid,',',b.help_topic_id+1),',',-1) source_class_id,
a.continue_time_start,
a.continue_time_end
FROM 
(
SELECT cb.id,cb.continuity_classid,cm.continue_time_start,cm.continue_time_end FROM education.classes_base cb LEFT JOIN  education.class_management  cm ON cb.course_id=cm.id) a
JOIN
mysql.help_topic b
ON b.help_topic_id < (LENGTH(a.continuity_classid) - LENGTH(REPLACE(a.continuity_classid,',',''))+1)
ORDER BY a.id;