偷学的sql宝库

递归遍历叶子结点（MySQL）

SELECT au.id, au.name, au.pid FROM (SELECT * FROM dept WHERE pid IS NOT NULL) au, (SELECT @pid := '1002,1005') pd WHERE FIND_IN_SET(pid, @pid) > 0 and @pid := concat(@pid, ',', id)