one to may relationship query

hi,

I am a bit struggling with this relation. not sure why....

Admin model. An admin has an employer

public function employer()
    {
        return $this->belongsTo(Employer::class);
    }

employer model. An employer has many admins

public function admins()
    {
        return $this->hasMany(Admin::class);
    }

The following query returns the relationship correctly but with too much data

$items = Admin::select('id', 'first_name', 'last_name', 'uuid', 'email', 'employer_id')->with('employer')->get();

I tried to trim the data to only get the employer name

$items = Admin::select('id', 'first_name', 'last_name', 'uuid', 'email', 'employer_id')->with('employer:name')->get();

but laravel returns null for the relationship

Best Answer

Level 75

$items = Admin::select('id', 'first_name', 'last_name', 'uuid', 'email', 'employer_id')
	->with('employer:id,name')
    ->get();

Docs: https://laravel.com/docs/8.x/eloquent-relationships#eager-loading-specific-columns

When using this feature, you should always include the id column and any relevant foreign key columns in the list of columns you wish to retrieve.

Please or to participate in this conversation.