I concure with the prescribed approach. Some databases, Oracle in particular, support this self referential table with an SQL syntax "CONNECT BY". You might check your favorite MySQL forum to see if there's corresponding idiom.

A similar problem is mentioned here: database table advice Update: I guess it's related because it's from the same author!

This problem shows up a lot in Bill-of-materials type applications.