急切加载访问数据透视表

Question

我有3个模型

1-书：

class Book extends Model
{
protected $guarded=[];
public function users(){return $this->belongsToMany(User::class);}  
public function bookUser(){return $this->hasMany(BookUser::class);} 
}

2-用户

class User extends Authenticatable
{
protected $guarded = [];
public function books(){return $this->belongsToMany(Book::class);}

3-书签用户

class BookUser extends Model
{
protected $guarded = [];
protected $table = 'book_user';
public function book(){return $this->belongsTo(Book::class);}
public function user(){return $this->belongsTo(User::class) ; }
}

bookuser迁移：

Schema::create('book_user', function (Blueprint $table) {
        $table->id();
        $table->timestamps();
        $table->foreignId('book_id')->constrained();
        $table->foreignId('user_id')->constrained();
        $table->boolean('like')->nullable()->default(0);
    });

我试图得到所有的书籍与喜欢的只是当前的用户：

public function index()
{
    id=Auth::user()->id;
    $books=Book::with('users')->get();
    return response()->json($books);   
}

这是我得到的：

[
{
    "id": 1,
    "created_at": "2021-03-22T14:16:30.000000Z",
    "updated_at": "2021-03-22T14:16:30.000000Z",
    "name": "power",
    "image": "978014444447899.jpg",
    "users": [
        {
            "id": 1,
            "name": "mark",
            "type": "reader",
            "image": null,
            "created_at": "2021-03-22T13:59:26.000000Z",
            "updated_at": "2021-03-22T13:59:26.000000Z",
            "pivot": {
                "book_id": 1,
                "user_id": 1,
                "created_at": "2021-03-22T14:20:26.000000Z",
                "updated_at": "2021-03-22T14:39:56.000000Z",
                "like": 1
            }
        }
    ]
}]

我如何访问数据透视表...或者如何得到那样的？？我正在尝试，但id不起作用

 $id=Auth::user()->id;
    
    $books=Book::with('users',function($query) {
    return $query->where('user.id','=',$id);
    })->get();

Answer 1

您只需使用use将$ID注入函数作用域

$id=Auth::user()->id;
    
$books=Book::with('users',function($query) use($id) {
    return $query->where('user.id','=',$id);
})->get();