ASP.NET Core多级分类问题：添加内容时展示层级化分类名称

核心思路 #

通过递归获取每个分类的完整父级路径，将路径拼接成「父分类 > 子分类 > 孙分类」的格式，最终在前端展示为结构化的选项列表。

1. 数据库层递归查询（推荐） #

利用数据库的递归查询能力直接生成完整路径，效率更高。以MySQL为例，使用CTE递归查询：

WITH RECURSIVE category_path AS (
    -- 初始化：获取所有顶级分类（假设parent_id=0为顶级）
    SELECT id, name, parent_id, CAST(name AS CHAR(255)) AS full_path
    FROM categories
    WHERE parent_id = 0
    -- 递归拼接子分类路径
    UNION ALL
    SELECT c.id, c.name, c.parent_id, CONCAT(cp.full_path, ' > ', c.name) AS full_path
    FROM categories c
    JOIN category_path cp ON c.parent_id = cp.id
)
-- 查询结果包含分类ID和完整路径
SELECT id, full_path FROM category_path ORDER BY full_path;

2. 后端递归拼接（兼容老数据库） #

如果数据库不支持递归查询，可以在后端通过代码递归遍历分类列表，拼接完整路径。以下是Python示例：

def build_category_full_paths(all_categories, parent_id=0, current_path=""):
    full_path_list = []
    # 筛选当前父级下的所有子分类
    child_categories = [cat for cat in all_categories if cat["parent_id"] == parent_id]
    for cat in child_categories:
        # 拼接当前分类的完整路径
        new_full_path = f"{current_path} > {cat['name']}" if current_path else cat["name"]
        full_path_list.append({"id": cat["id"], "full_path": new_full_path})
        # 递归处理子分类的子分类
        full_path_list.extend(build_category_full_paths(all_categories, cat["id"], new_full_path))
    return full_path_list

# 示例：从数据库获取的全部分类数据
all_categories = [
    {"id": 1, "name": "分类1", "parent_id": 0},
    {"id": 2, "name": "一级子分类", "parent_id": 1},
    {"id": 3, "name": "二级子分类", "parent_id": 2},
    {"id": 4, "name": "分类2", "parent_id": 0},
    {"id": 5, "name": "一级子分类", "parent_id": 4},
]

# 生成带完整路径的分类列表
category_options = build_category_full_paths(all_categories)

3. 前端渲染 #

将后端生成的带完整路径的分类数据渲染为下拉选择框，以PHP+HTML为例：

<select name="category_id" required>
    <?php foreach ($category_options as $option): ?>
        <option value="<?= $option['id'] ?>"><?= $option['full_path'] ?></option>
    <?php endforeach; ?>
</select>

渲染后会得到如下格式的选项：

分类1 > 一级子分类 > 二级子分类
分类2 > 一级子分类

内容的提问来源于stack exchange，提问作者mohammad