mysql查询字段按分隔符一行分成多行语句

mysql查询字段d_path按下划线一行分成多行语句

例 d_path：_0_1_2_3_4_5_

SELECT DISTINCT
    d.id,
    substring_index(substring_index( d.d_path,'_',b.help_topic_id+1),'_',-1) 
FROM
    xxx_d_table d
    JOIN mysql.help_topic b ON b.help_topic_id<(LENGTH(d.d_path)-LENGTH(REPLACE(d.d_path, '_', ''))+1)
    AND d.d_path like '%_3_%';