Storing Hierarchical Data in a Database [PHP & MySQL Tutorials]
"There are two major approaches: the adjacency list model, and the modified preorder tree traversal algorithm. In this article, we'll explore these two methods of saving hierarchical data."