tp6表关联，关联查询

tp6表关联，关联查询

 // 模型里表关联
    public function getexample()
    {
        return $this->hasOne(Example::class, 'id', 'example_id')->field('id,title');
    }

public function sucai()
    {
        $page = input('page/d', 1);
        $listRows = 8;
        $user_id = $this->user_id;
        $model = new ExampleDownload();
        $example = $model->where('member_id', $user_id)
            //with关联
            ->with('getexample')
            ->field('id,example_id,created_at')
            ->page($page, $listRows)
            ->order('created_at', 'desc')
            ->select();
        foreach ($example as $v) {
            //关联查询变量
            $v['title'] = $v->getexample->title;
            //销毁变量
            unset($v->getexample);
        }
        $count = count($model->where('member_id', $user_id)->select());
        $maxpage = ceil($count / $listRows);
        return sucessMsg(200, '请求成功', ['example' => $example, 'page' => $page, 'maxpage' => $maxpage]);
    }