thinkphp模型递归查询

最新推荐文章于 2023-12-18 16:41:24 发布

qq_42289686

最新推荐文章于 2023-12-18 16:41:24 发布

阅读量635

点赞数

文章标签： php

本文链接：https://blog.csdn.net/qq_42289686/article/details/131711669

版权

效果图：

树状表格示意图

查询代码：

use app\model\Menu;

function getMenuList(string $uid)
{
    $list = Menu::where('pid', $uid)->select();
    foreach ($list as $val) {
        $val['children'] = getMenuList($val->uid);
    }
    return $list;
}

function getMenuBelong(string $uid)
{
    $has = [];
    $list = Menu::where('pid', $uid)->select();
    foreach ($list as $val) {
        $has[] = $val->id;
        $next = getMenuBelong($val->uid);
        $has = array_merge($has, $next);
    }
    return $has;
}

模型

<?php

namespace app\model;

use think\Model;

class Menu extends Model
{
    // 设置字段信息
    protected $schema = [
        'id' => 'int',
        'menu_title' => 'string',
        'menu_type' => 'int',
        'cate_uid' => 'string',
        'use_cate_uid' => 'int',
        'open_tag' => 'int',
        'uid' => 'string',
        'pid' => 'string',
        'order_sort' => 'int',
        'create_time' => 'int',
    ];
    protected $autoWriteTimestamp = 'create_time';
}