摘要： 在8之前一般都是写递归函数实现， 另一种方式: stackoverflow的解决方案,亲测有效: SELECT * FROM person WHERE department IN (SELECT department_id FROM department WHERE department_id = 阅读全文