PHP와 MySQL을 사용하여 무제한 수준의 메뉴를 구축하는 방법: 단계별 가이드?

<code class="php">$list = $obj->childmenu($parentid);
foreach($list as $menu) {
    echo '<li><a href="#">'.$name.'</a></li>';
}</code>

<code class="sql">SELECT id, parent_id, title, link, position FROM menu_item ORDER BY parent_id, position;</code>

<code class="php">$items = $query_results;  // Assuming $query_results contains the result of the SQL query

$html = '';
$parent = 0;
$parent_stack = array();

foreach ( $items as $item ) {
    if ( !empty($item['parent_id']) ) {
        $children[$item['parent_id']][] = $item;
    }
}

while ( ( $option = each( $children[$parent] ) ) || ( $parent > 0 ) ) {
    if ( !empty( $option ) ) {
        if ( !empty( $children[$option['value']['id']] ) ) {
            $html .= '<li>' . $option['value']['title'] . '<ul>';
            array_push( $parent_stack, $parent );
            $parent = $option['value']['id'];
        } else {
            $html .= '<li>' . $option['value']['title'] . '</li>';
        }
    } else {
        $html .= '</ul>';
        $parent = array_pop( $parent_stack );
    }
}

echo $html;</code>