mysql 怎么实现sql的with递归

DECLARE @test_dbcc TABLE ( 表编号 VARCHAR(50) , 父级GID VARCHAR(50) ); WITH DEPT_TREE AS ( SELECT 表编号 , 父级GID FROM [资源_科目表] WHERE 父级GID = @表编号 UNION ALL SELECT d.表编号 , d.父级GID FROM [资源_科目表] D JOIN DEPT_TREE H ON D.父级GID = H.表编号 ) INSERT INTO @test_dbcc SELECT * FROM DEPT_TREE 我应该在mysql里怎么写？最好写详细点，用临时表写完结果不对