tp5分页并两表联合查询

tp5分页并两表联合查询

    public function adc()

    {

        $where = [];

        if (input('?name')) {

            $name = input('name');

            $where['name'] = ['like', "%$name%"];

        }

        // 分页

        $list = db('shanpin')->alias('a')

            ->where($where)

            ->order('id', 'desc')

            ->field('a.*,u.id as yid,u.name as uname')

            ->join('fenlie u', 'u.id = a.fenid')

            ->paginate(8, false, ['query' => request()->param()]);

        $this->assign('list', $list);

        $pag = $list->render();       

        $this->assign('pag', $pag);

        return $this->fetch();

    }