偷学的sql宝库Boyu Lin·Oct 17, 2023递归遍历叶子结点(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) SQL Share this