Buon giorno.
Ho la tabella "tb_menu" strutturata come di seguito:

id - label - parent
1 - PRS - 0
2 - FENDER - 0
21- Santana - 1
22- Tremonti - 1
86- Hendrix - 2
86- Malmsteen - 2
90- 1974 - 21
91- 1975 - 21
92- AX1 - 22
93- AX2 - 22

Devo realizzare un menu accordion.
Riesco soltanto a visualizzare la voce padre, ma non i figli.
[php]
$query= $this->connect->query("SELECT a.id, a.label, a.folder, a.parent,a.link, Deriv1.Count FROM".tb_menu." a
LEFT OUTER JOIN (SELECT parent, COUNT(*) AS Count FROM ".tb_menu." GROUP BY parent) Deriv1
ON a.id = Deriv1.parent WHERE a.parent=".$parent);




$menu_navbar= "<div id='sidebar-wrapper' style='overflow-x: hidden;'>
<ul class='sidebar-nav' style'font-family:myFirstFont;src: url(../fonts/TitilliumWebRegular/TitilliumWebRegular.woff)'>";
$menu = array();
while ($row = mysqli_fetch_assoc($query)) {
if($row['Count']>0){
$menu[$row['parent']][] = array($row['label']);
}
}
$i=1;
$menu_navbar .= "<li class='togliSpazio'><span></span><a href='#' ".($l[0]!='' ? "class='accordion'" : "")." ".(strlen($lista)>=30 ? "style='text-align:left;line-height:18px'" : "").">".
utf8_encode($lista)."</a>";
$menu_navbar .= "<ul data-index='".$i."' class='panel togliSpazio'>";


/*foreach($l as $link){
$menu_navbar .= "<li>B<a href='/at/".sanitizeLinkAT(utf8_encode($lista))."/".sanitizeLinkAT(utf8_encode($link)).".html?id =$i' ".(strlen($link)>=25 ? "style='text-align:left;line-height:20px;width:90%'" : "").">".
utf8_encode($link)."</a></li>";
}*/


$menu_navbar .= "</ul>
</li>";
$i++;
}
$menu_navbar.= "</ul>
</div>";
//var_dump($menu);
echo $menu_navbar;
[/php]

Come faccio?
Grazie.