如何从数据透视表中找到所有id pivot？ （laravel 5.3）

Question

I have a pivot table. The name is users_banks table. The table have field id, user_id, bank_id, status, account_name and account_number

Now, the pivot have 3 records

I display contain from pivot table using code like this :

$user_id = auth()->user()->id;
$user = $this->user_repository->find($user_id);

$account = array();
foreach($user->banks as $bank) {
    $account[] = $bank;
}

dd($account);

The result display all record in the form of array. There exist value of field user_id, bank_id, status etc. But I don't find value of id

How can I find id from pivot table?

Answer 1

If the relationship is defined correctly you can use:

$bank->pivot->id

but make sure the user belongsToMany(Bank::class) and the bank belongsToMany(User::class) or else it wont work.