WITH RECURSIVE modt AS (
SELECT ID
,
typeid,
cname,
parentid,
score,
days,
typedesc,
idx
FROM
tb_method_type
WHERE
parentid = '0000000'
AND status = '1' UNION ALL
SELECT
tmt.ID,
tmt.typeid,
tmt.cname,
tmt.parentid,
tmt.score,
tmt.days,
tmt.typedesc,
tmt.idx
FROM
tb_method_type tmt
JOIN modt ON tmt.parentid = modt.typeid
AND tmt.status = '1'
) SELECT
modt.*
FROM
modt
ORDER BY
modt.idx ASC
id=‘0000000’下所有子数据,递归查询出来