多对多关联 limit 查询有问题

浏览:3557 发布日期:2020/02/18 分类:ThinkPHP6专区 关键字: thinkphp6,tp6,limit,withLimit
多对多关联 limit 查询有问题,限制的是所有数据的limit并不是关联数据下的limit, withLimit也是一样的
可有解?$data = $this->mediaItemFlagModel()->with([
            'item' => function (Relation $query) {
                $query->with('image')
                    ->field('id,title,type,is_free,vip_free,market_price,sales_price,vip_price,image,browse,check,status,order')
                    ->where('check', true)
                    ->where('status', 1)
                    ->order('order', 'desc')
                    ->withLimit(1)
                ;
            }
        ])
            ->field('id,name,description')
            ->where('status',1)
            ->order('order')
            ->select();
返回的数据"flag": [
            {
                "id": 1,
                "name": "asdasd",
                "item": [
                    {
                        "id": 93,
                        "title": "下",
                        "type": 1,
                        "order": 61,
                        "pivot": {
                        "media_id": 93,
                            "flag_id": 1
                        }
                    }
                ]
            },
            {
                "id": 14,
                "name": "测试专区 请勿删除",
                "description": "测试专区 请勿删除",
                "item": []
            }
        ]
    }
最佳答案
评论() 相关
后面还有条评论,点击查看>>