查询empid=2下的所有记录WITH RECURSIVE r AS (SELECT * FROM emp WHERE empid = 2union ALLSELECT emp.* FROM emp, r WHERE emp.empparid = r.empid)
