baseXX/application/admin/model/special/SpecialTaskCategory.php

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------

namespace app\admin\model\special;

use traits\ModelTrait;
use basic\ModelBasic;
use service\UtilService as Util;
use app\admin\model\special\SpecialTask;

class SpecialTaskCategory extends ModelBasic
{
    use ModelTrait;

    /**
     * 全部素材分类
     */
    public static function taskCategoryAll($type=0){
        $model=self::where('is_del',0);
        if($type==1){
            $model=$model->where('pid',0);
        }
        $list=$model->select();
        $list=count($list) > 0 ? $list->toArray() : [];
        $list=Util::sortListTier($list);
        return $list;
    }
    /**
     * 素材分类列表
     */
    public static function getAllList($where){
        $data = self::setWhere($where)->page((int)$where['page'], (int)$where['limit'])->select();
        $data=count($data) > 0 ? $data->toArray() : [];
        foreach ($data as &$item){
            $pids=self::categoryId($item['id']);
            if(count($pids)>0){
                $item['sum']=SpecialTask::where("pid",'in', $pids)->count();
            }else{
                $item['sum']=SpecialTask::where("pid", $item['id'])->count();
            }
        }
        $count = self::setWhere($where)->count();
        return compact('data', 'count');
    }

    public static function setWhere($where)
    {
        $model = self::order('sort desc,add_time desc')->where('is_del', 0)->where('pid',$where['pid']);
        if ($where['cate_name'] != '') $model = $model->where('title', 'like', "%$where[cate_name]%");
        return $model;
    }

    /**获取一个分类下的所有分类ID
     * @param int $pid
     */
    public static function categoryId($pid=0){
        $data=self::where('is_del', 0)->where('pid',$pid)->column('id');
        return $data;
    }
}