phpcms添加二级菜单

CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `submenu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`)
);

INSERT INTO `menu` (`name`) VALUES ('主菜单1');
INSERT INTO `menu` (`name`) VALUES ('主菜单2');

INSERT INTO `submenu` (`menu_id`, `name`) VALUES (1, '子菜单1-1');
INSERT INTO `submenu` (`menu_id`, `name`) VALUES (1, '子菜单1-2');
INSERT INTO `submenu` (`menu_id`, `name`) VALUES (2, '子菜单2-1');

<?php
// 连接数据库
$conn = new mysqli('localhost', 'username', 'password', 'database_name');

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取主菜单
$sql = "SELECT * FROM menu";
$main_menu_result = $conn->query($sql);

if ($main_menu_result->num_rows > 0) {
    while($row = $main_menu_result->fetch_assoc()) {
        echo "<li>" . $row["name"] . "<ul>";
        
        // 获取子菜单
        $submenu_sql = "SELECT * FROM submenu WHERE menu_id = " . $row["id"];
        $submenu_result = $conn->query($submenu_sql);
        
        if ($submenu_result->num_rows > 0) {
            while($submenu_row = $submenu_result->fetch_assoc()) {
                echo "<li>" . $submenu_row["name"] . "</li>";
            }
        }
        
        echo "</ul></li>";
    }
}
$conn->close();
?>