single mysql query that show a particular parent and child value I am facing problem to show a particular parent child value and under all child value as a relationship. I have created single table tree and three column id, child and parent.

I created a tree relationship but I don't understand how to fetch a particular parent child and his child and his child value for tree. Can you help me?
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.