How to make a hierarchical table structure?

Question

MySQL

Good day! Need to make a table with display

levels

.
That is, the levels here mean those whom you invited and those who were invited by the one you invited .. so .. How to do this?
Are there any plugins or something?

Thanks in advance

Answer 1

To store tree-like (hierarchical) data in relational databases, the following structures are usually used:

• materialized path
  
• Nested Set
  
• Adjacency List
  

Answer 2

Clumsily it becomes in the form of self reference communications. In the real world, graph databases are used for this.