The table of members has member's name, their id and the leader's id (which is the member id of the group leader)
Example of table
| mem_id | mem_name | group_leader_id |
| ------ | -------- | ----------------|
| 100 | LDRNAMEA | NULL |
| 141 | Emp.B | 100 |
| 142 | Emp.C | 100 |
| 200 | LDRNAMEB | NULL |
| 242 | Emp.d | 200 |
and I want my result to be like
| group_leader_name| emp_name |
| -----------------| -------- |
| LDRNAMEA | Emp.C |
| LDRNAMEA | Emp.B |
| LDRNAMEB | Emp.d |
how to get the leader name by their member id and list all the employee with their leader's name?
