Php algorithm-how to use PHP to implement infinite upper-lower-level recursive queries?

The name of a family table is ** family **. The ** idspouseidfatherid ** fields are the id of the spouse and the ID of the father respectively. Excuse me, only one ** id ** is provided **, you can find the statement ** all elders and lower generations ** and the kinship with the ** given ID **. how can I write this statement? Now the logic is stuck. if you can, try to parse it in detail. thank you ~ Php algorithm tree mysqlphptreeview

It is a family table.

Table nameFamily. Which hasId spouseid fatheridThree fields
IdIt's me, and the last two are my spouse's ID and my father's ID.

Excuse me, only oneId, You can queryAll elders and eldersAndKinship of the given IDHow to write the statement? Now the logic is stuck. if you can, try to parse it in detail. thank you ~