IF OBJECT_ID('employes') IS NOT NULL
DROP TABLE employes

IF OBJECT_ID('employes') IS NULL
CREATE TABLE employes(
ID int IDENTITY (1,1) PRIMARY KEY ,
Code varchar(50) not null UNIQUE,
Post varchar(50) not null,
Name varchar(255) not null,
DateBegin date not null,
DateEnd date null,
ID_Parent int null 
);
GO 

INSERT employes values 
('0001','General director','Ivanov','20000101', NULL, NULL),
('0002','The leader of team 1','Petrov','20000101', NULL, NULL),
('0003','The leader of team 2','Sidorov','20000101', NULL, NULL),
('0004','Employe 1','Klyshkina','20000101', NULL, NULL),
('0005','Employe 2','Mishustina','20000101', NULL, NULL),
('0006','Employe 3','Kotelnikov','20000101', NULL, NULL),
('0007','Employe 4','Sidelnikova','20000101', NULL, NULL),
('0008','Employe 5','Mokrushin','20000101', '20200502', NULL),
('0009','Employe 6','Malenkay','20000101', NULL, NULL),
('0010','Employe 7','Bolshoy','20000101', '20210315', NULL),
('0011','Employe 8','Ivanov','20000101', NULL, NULL),
('0012','Employe 9','Sidorov','20000101', NULL, NULL);

UPDATE employes SET ID_Parent = 1
WHERE code = '0002' OR code = '0003'
UPDATE employes SET ID_Parent = 2
WHERE code = '0004' OR code = '0005' OR code = '0006'
UPDATE employes SET ID_Parent = 3
WHERE code = '0007' OR code = '0008' OR code = '0009'
UPDATE employes SET ID_Parent = 9
WHERE code = '0010' OR code = '0011'
UPDATE employes SET ID_Parent = 11
WHERE code = '0012';


WITH Subordinates AS (
SELECT * FROM employes AS e
WHERE e.ID = 3

UNION ALL

SELECT * FROM employes AS e
JOIN Subordinates AS sub ON e.ID_Parent = sub.ID
)

SELECT * FROM Subordinates