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

| id | parent_id | name | ... |

<code class="php">function childMenu($parentId) {
    $sql = "SELECT * FROM menu WHERE parent_id = ?";
    $stmt = $pdo->prepare($sql);
    $stmt->execute([$parentId]);
    return $stmt->fetchAll();
}</code>

<code class="php">function childMenu($parentId) {
    $sql = "SELECT * FROM menu WHERE parent_id = ? OR id = ?";
    $stmt = $pdo->prepare($sql);
    $stmt->execute([$parentId, $parentId]);
    return $stmt->fetchAll();
}</code>

<code class="php">$html = '';
$list = childMenu(0);

foreach ($list as $menu) {
    if (childMenu($menu['id'])) {
        $html .= "<li><a href=\"#\">{$menu['name']}</a>" .
            "<ul>" . createMenu($menu['id']) . "</ul>" .
            "</li>";
    } else {
        $html .= "<li><a href=\"#\">{$menu['name']}</a></li>";
    }
}

return $html;</code>