Follow Steps:
--1.Creating the Employee table
CREATE TABLE Emp(emp_id int, manger_id int,employee_name varchar(20))
--2.Inserting the value
INSERT INTO Emp VALUES(1,1,'T1'),(2,1,'T2'),(3,2,'T3'),(4,1,'T4')
--3.The self join query
SELECT emp.emp_id,emp.employee_name
[Emb], mgr.employee_name
[Manager] FROM Emp, Emp
mgr WHERE emp.manger_id = mgr.emp_id