There are lots of ways in SQL to provide nested/heirarchical data, each with their own strengths and weaknesses.

* Adjacency List Model

* Path Enumeration Model, also known as the Materialized Path

* Closure Table Model (or Bridge Table)

* Nested Set Model

* Recursive CTEs