parent and child value in a same query

Hello All

i want to make a dataset. i am having one sql data table.

in which columns are id name parentid.

now i want value in a like first row will parent id.
then all the rows with above id is as parent id.

then again next parent.


How can i achive this.

Thanks and Regards,
Omkar.