Let’s say a user added two leaves, as shown in the figure below:

You can find leaves added to users from table TB_LEAVE.

You can find which type these leaves are of from table TB_LEAVE_ITEM. Compare the column nType in both tables.

You can find who have these leaves from table TB_TA_USER. You can use columns nTAIdn and nUserTAIdn as a matching key.