WITH TempTable(ID,Name,ReportingTo)
AS
(
SELECT e.empID,e.empName,e.empReportingTo FROM Employee_MAster e
WHERE e.empID = `JSD001`
UNION ALL
SELECT e.empID,e.empName,e.empReportingTo FROM Employee_MAster e, TempTable temp
WHERE e.empID = temp.ReportingTo
)
SELECT * FROM TempTable