[0] Категория
--------[0][0] Подкатегория
----------------[0][0][1] Подкатегория
----------------[0][0][2] Подкатегория
----------------[0][0][n] ....................
--------------------------------[0][0][n][n] ....................
--------------------------------[0][0][n][n] ....................
--------------------------------[0][0][n][n] ....................
--------[0][1] Подкатегория</span>

echo '<pre>Fetched users';
    print_r($fetchedUsers);
    echo '</pre>';

$result = $core->database->select("SELECT * FROM ?_shopcats");
for($i=0; $i<count($result); $i++)    
    {
        $cats[$result[$i]['id']]['id'] = $result[$i]['id'];
        $cats[$result[$i]['id']]['parentId'] = $result[$i]['parentId'];
        $cats[$result[$i]['id']]['cat_title'] = $result[$i]['cat_title'];
    }

    $fetchedUsers = array();
    function doQuery($ids, $order = 1,$cats = NULL)
    {
        switch ($order)
        { case 1: return $cats; }
    }
    $order = 1;
    $users = doQuery($userId, $order,$cats);
    do {
        $idsToFetch = array();
        if (is_array($users))
        {
            $idsToFetch = array_diff_key($users, $fetchedUsers);
            if (empty($idsToFetch))
                break; 

            $fetchedUsers += $users;
            $users = doQuery($idsToFetch, ++$order,$cats);
        }
    } while (!empty($idsToFetch));

    $tree = array();
    foreach($fetchedUsers as $id => &$user)
    {
        if ($user['parentId'] == 0)
            $tree[$id] =& $user;
        else
            $fetchedUsers[$user['parentId']]['items'][$id] =& $user;
    }
    unset($fetchedUsers);

    echo '<pre>Tree';
    print_r($tree);
    echo '</pre>';

<?
function testparent ($id,$tabs) {
$tabs = $tabs."--- ";
   $sql = "SELECT * FROM menuv2 WHERE parent='$id'";
   $result = mysql_query($sql) or die(mysql_error());
   while ($row = mysql_fetch_assoc($result)) {
      menuv2($row['id'],$tabs);
      };
   };
   
function menuv2($parent,$tabs) {
   //$tabs = $tabs."--- ";
   $sql = "SELECT * FROM menuv2 WHERE id='$parent'";
   $result = mysql_query($sql) or die(mysql_error());
    while ($row = mysql_fetch_assoc($result)) {
	   echo ($tabs.$row['name']."<br>");
	   testparent ($row['id'],$tabs);
	   }
   };

  // $tabs = "---";
$sql = "SELECT * FROM menuv2 WHERE parent=''";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
   menuv2($row['id'],$tabs);
   };
   
?>