how to display Hierarchical structure database table

Question

Hello Friends ,

I am struck in one problem related to database  table.

My table STructure is . 

 

Parent ID  id   name   subject  

1                1   rakesh  math

2                2   kumar   sci

1                3   ramesh ssc

2                4    rohit     eng

1                5    tom    eng

 

 

i want output like this  order of data like this only

 

parent	name	subject
1	rakesh	math
	ramesh	ssc
	tom	eng
2	kumar	sci
	rohit	eng

 

 please help me