WITH RECURSIVE info AS ( -- 初始查询,过滤掉 course 为 NULL 或空字符串的记录 SELECT info_id, SUBSTRING_INDEX(concat(course,','), ',', 1) AS value, SUBSTRING(concat(course,','), LOCATE(',', concat(course,',')) + 1) AS remaining, 0 lv FROM cultivate_tb WHERE course IS NOT NULL UNION ALL -- 递归查询,继续拆分剩余部分 SELECT info_id...