Recursion to get a tree from a id-parent sql table

get_tree_from_table.php

<?php

// I use here Jeff's db methods

public function getTree($registry, $parent=0) {

  $child_rows = $registry->db->autoSelect("id", TABLE, "parent='$parent'", "name");

  $children = array();

  foreach($child_rows as $row) {
    $children[$row['id']] = self::getTree($registry, $row['id']);
  }

  return $children;

}

?>

so if there are 100 child rows, you recursively make 100 SQL queries?

Since this snippet is used to retrieve a menu tree, this is not the case