查询三级商品分类列表

Controller类

@GetMaping("/{level}")
public static find(@PathVariable Integer level){
    List<ItemCat> itemCatList = itemCatService.find(level);
    return SysResult.success(ItemCatList);
}

ItemCatService类:

        第一种:嵌套查询数据库

public List<ItemCat> find(Integer level){
    //1.查询一级商品分类信息
    QueryWrapper<ItemCat> queryWrapper = new QueryWrapper<>();
    queryWrapper.eq("parent_id", 0);
    List<ItemCat> oneList = itemCatMapper.selectList(queryWrapper);
    
    //2.查询二级商品分类信息  遍历一级集合
    for(ItemCat oneItemCat : oneList){
        queryWrapper.clear();   
        queryWrapper.eq("parent_id", oneItemCat.getId());
        List<ItemCat> twoList = itemCatMapper.selectList(queryWrapper);

        //3.查询三级商品分类信息遍历
        for(ItemCat twoItemCat : twoList){
            queryWrapper.clear();
            queryWra