single mysql query that show a particular parent and child value
By the way the same question has been already asked/answered and I would recommand you reading the article of the answer.

The article propose another solution which is less expensive to list parent/children : "The Nested Set Model" method which use these columns : id, left, right. 
You will have to manage by yourself (or by your application) the left/right value.