laravel - OrderBy 工作但不是在哪里

Question

这工作正常。

$q=Question::with(['users'=>function($query)
    {
        $query->orderBy('pivot_approved','desc');
    }])->get();

这不会:

 $q=Question::with(['users'=>function($query)
        {
            $query->where('pivot_approved',1);
        }])->get();

还尝试在关系中使用 wherePivot:

public function users()
{     
    return $this->belongsToMany('App\User','question_user','q_id','user_id')->wherePivot('approved',1);  
}

Answer 1

尝试添加 withPivot() 首先是关系:

->withPivot('approved');

By default, only the model keys will be present on the pivot object. If your pivot table contains extra attributes, you must specify them when defining the relationship