php - Accessing a foreign key on Laravel

Question

I have two tables (User and Role) that are related through an foreign key in User (role field).

I made the relations on the models and trying to access the Role name from inside a blade file.

User model

class User extends Authenticatable
{
    protected $table = 'users';

    protected $fillable = ['name', 'password', 'role'];


    public function roles()
    {
        return $this->belongsTo('AppModelsRole', 'role');
    }

}

Role Model

class Role extends Model
{
    protected $table = 'roles';

    protected $fillable = 'name';

    public function user()
    {
        return $this->hasOne('AppModelsUsers', 'role');
    }

}

Inside the index function on my User controller I try to call

'users' => User::with('roles')->get()

but I get this error:

ErrorException thrown with message "count(): Parameter must be an array or an object that implements Countable"

What could be the reason?

Also, if I do

'users' => DB::table('users')->get()

I get the users but can't get the name of the role inside the view.

Answer 1

等待大神答复