dedecms获取三级导航

<?php
// 假设已经连接到数据库
$mysqli = new mysqli("localhost", "username", "password", "dedecms");

// 查询导航菜单数据
$query = "SELECT id, name, reid FROM dede_arctype WHERE reid = 0";
$result = $mysqli->query($query);

$navData = [];
while ($row = $result->fetch_assoc()) {
    $navData[$row['id']] = [
        'name' => $row['name'],
        'children' => []
    ];
}

// 查询子菜单数据
$query = "SELECT id, name, reid FROM dede_arctype";
$result = $mysqli->query($query);

while ($row = $result->fetch_assoc()) {
    if (isset($navData[$row['reid']])) {
        $navData[$row['reid']]['children'][$row['id']] = [
            'name' => $row['name'],
            'children' => []
        ];
    }
}

// 递归处理生成三级导航结构
function buildNav($data) {
    $html = '<ul>';
    foreach ($data as $key => $item) {
        $html .= '<li>' . $item['name'];
        if (!empty($item['children'])) {
            $html .= buildNav($item['children']);
        }
        $html .= '</li>';
    }
    $html .= '</ul>';
    return $html;
}

echo buildNav($navData);
?>