Unnamed

$data = array();$dbquery = "SELECT id,name FROM table WHERE parent_id IS NULL";while(list($id,$name)=$dbfetch){    $outer = array("id"=>$id,"name"=>$name);    $inner = array();    $dbquery = "SELECT id,name FROM table WHERE parent_id=$id";    while(list($sub_id,$sub_name)=$dbfetch){        $inner[] = array("id"=>$sub_id,"name"=>$sub_name");    }    $outer["subs"] = $inner;    $data[] = $outer;}$smarty->assign("categoryList",$data);