php - Laravel Many to Many relationship only works for first record

I have 2 tables and 1 pivot table with many to many relationship. However the relationship only works for the first record, for the second record onwards, the relationship can't be detected.

These are my tables. Roles, Admins and my pivot table is admin_role.

Model

Admin.php

<?php

namespace App;

use App\Role;
use App\Notifications\AdminResetPasswordNotification;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;

class Admin extends Authenticatable
{
    use Notifiable;

    //Send Notification
        /**
     * Send the password reset notification.
     *
     * @param  string  $token
     * @return void
     */
    public function sendPasswordResetNotification($token)
    {
        $this->notify(new AdminResetPasswordNotification($token));
    }
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name', 'email', 'password',
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password', 'remember_token',
    ];

    /**
     * Relationships
    */
    public function role() 
    {
        return $this->belongsToMany(Role::class)->using('App\RoleAdmin');
    }


}
Copy code

Role.php

<?php

namespace App;
use App\Admin;
use Illuminate\Database\Eloquent\Model;

class Role extends Model
{
    public function admin()
    {
        return $this->belongsToMany(Admin::class)->using('App\RoleAdmin');
    }
}
Copy code

RoleAdmin.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\Pivot;

class RoleAdmin extends Pivot
{
    protected $table = 'admin_role';

    protected $fillable = ['admin_id' , 'role_id'];


}
Copy code

So the problem right now is

$admin = App\Admin::find(1);
$admin->role()->get();
Copy code

When I run the above method, I can retrieve back record.

Same for this

$role = App\Role::find(1);
$role->admin()->get();
Copy code

However for this,

$admin = App\Admin::find(2);
$admin->role()->get();
Copy code

And

$role = App\Role::find(2);
$role->admin()->get();
Copy code

There are no records.

UPDATE : AdminRoleTable looks like this

id    admin_id   role_id 
1        1          1
2        2          2
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.