将数字放入：
1 Big Boss 14 / 2 Brian 7 8 Susan 13 ||3 Susan 6 9 Mary 12 ||4 Bob 5 10 Bob 11
如果可以指定我们知道它的“ Susan”，
8则：
SELECt employee.* FROM Personnel AS employeeinner join Personnel AS manager on employee.lft BETWEEN manager.lft AND manager.rgtWHERe employee.name = 'Bob' and manager.name = 'Susan' and manager.lft = 8ORDER BY employee.lft
否则，我认为您需要了解更多有关记录的信息，以指定您要说的是哪个经理。
select employee.*from Personnel employee inner join (SELECt node.name, node.lft, node.rgt, (COUNT(parent.name) - 1) AS depth FROM Personnel AS node inner join Personnel AS parent on node.lft BETWEEN parent.lft AND parent.rgt GROUP BY node.name, node.lft, node.rgt) as manager on employee.lft between manager.lft and manager.rgt where employee.name = 'bob' and manager.name = 'susan' and manager.depth = 1
