Find a recursive algorithm solution

Find a recursive algorithm id & nbsp; name & nbsp; pid1 & nbsp; & nbsp; AAA & nbsp; & nbsp find a recursive algorithm
Id name pid
1 AAA 0
2 BBB 1
3 CCC 2
4 DDD 2
5 EEE 0
6 FFF 5
7 GGG 6

Obtain

AAA
BBB
CCC => 'CCC'
DDD => 'ddd'
EEE
FFF
GGG => 'GGG'
------ Solution --------------------
Http://bbs.csdn.net/topics/390731721
------ Solution --------------------

function tree($pid=0) {
  $res = array();
  $rs = mysql_query("select * from tbl_name where pid=$pid");
  while($row = mysql_fetch_assoc($rs)) {
    $res[$row['name']] = ($t = tree($row['id'])) ? $t : $row['name'];
  }
  return $res;
}

------ Solution --------------------
The principle is the same. the landlord can modify the code in the link on the first floor to meet the requirements.