Multiple Descendants in Family Relationships in PHP

In the previous lesson, a father could only have one son. This was achieved because the father had a relation son_id.

Now let a father have several sons. In this case, we can still make only one table, which will be related to itself. Only in the relation field we will store not the id of the son, but the id of the father. In this case, several users will be able to reference their father - and thus the father will have several sons:

users
id	name	father_id
1	user1	3
2	user2	3
3	user3	4
4	user4	null

You can get a user along with his father as follows:

sqlSELECT
  users.name as user_name,
  fathers.name as father_name
FROM
  users
LEFT JOIN users as fathers ON fathers.id=users.father_id

Задание 1

Suppose we have users. Each user has a father and a mother. Describe the storage structure.

Задание 2

Write a query that will fetch a user along with his father and mother.