# 偷学的sql宝库

### 递归遍历叶子结点（MySQL）

SELECT [au.id](http://au.id), [au.name](http://au.name), [au.pid](http://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)