Get upto second child!

gistfile1.php

<?php
$q = "SELECT * FROM table WEHRE parent=0" ;
$res  = mysql_query($q);
while ($row = mysql_fetch_array($res)){
   $q1 = "SELECT * FROM table WHERE parent = ". $row['id'];
	$res1 = mysql_query($q1);
	while($row1 =  mysql_fetch_array($res1){
		$q2 = "SELECT * FROM table WHERE parent = ". $row1['id'];
		$res2  = mysql_query($q2);
		while($row2 = mysql_fetch_array($res2)){
			//echo Parent: $row
			// First Child: $row1
			// Second Child: $row2
		}
	}
}