关联模型 模型值为空 期望关联模型值为空的直接不显示

浏览:760 发布日期:2020/05/25 分类:ThinkPHP6专区
使用一对一关联,关联模型条件查询出来值为空,但是这条数据却显示出来了,不知道什么地方是否写错,求大佬指导下self::with([
                'user' => function ($query) use ($likeSearch){
                    if (!empty($likeSearch['record'])) {
                        $query->where($likeSearch['record']);
                    }
                },
            ])->where($likeSearch['user'])->where($timeSearch)->limit($length[0], $length[1])->order($sortName, getSortOrder())
                ->select()->toArray();
{
    "code": 200,
    "message": "success",
    "data": {
        "item": [
            {
                "id": 1,
                "userId": 1,
                "image": "http://127.0.0.1/tea/public/uploads/img/20200522/980c5f2834704838a8c77058496fdac7.jpg",
                "result": "咖啡",
                "recordTime": "2020-05-25 14:59:51",
                "user": null
            },
            {
                "id": 4,
                "userId": 1,
                "image": "http://127.0.0.1/tea/public/uploads/img/20200522/980c5f2834704838a8c77058496fdac7.jpg",
                "result": "红茶",
                "recordTime": "2020-05-23 14:59:51",
                "user": null
            },
            {
                "id": 3,
                "userId": 1,
                "image": "http://127.0.0.1/tea/public/uploads/img/20200522/980c5f2834704838a8c77058496fdac7.jpg",
                "result": "黑茶",
                "recordTime": "2020-05-22 14:59:51",
                "user": null
            },
            {
                "id": 2,
                "userId": 1,
                "image": "http://127.0.0.1/tea/public/uploads/img/20200522/980c5f2834704838a8c77058496fdac7.jpg",
                "result": "茶叶",
                "recordTime": "2020-05-09 14:59:51",
                "user": null
            }
        ],
        "page": 1,
        "page_size": 20,
        "count": 4
    }
}
最佳答案
评论( 相关
后面还有条评论,点击查看>>