Laravel how to load specific column of related table? [duplicate]

Question

I have the following code, what I want is to take specific columns of related tables.

auth()->user()->load(['business', 'passwordSecurity']);

thefallen · Accepted Answer · 2019-08-29 06:19:22Z

3

To select only specific columns from a relationship you should be able to do it like this:

auth()->user()->load([
    'business' => function ( $query ) {
        $query->select('id', 'title');
    },
    'passwordSecurity',
]);

Or like this:

auth()->user()->load(['business:id,name', 'passwordSecurity']);

Please note that you have to select IDs and foreign key constraints that are needed to form this relationship.

answered Aug 29, 2019 at 6:19

thefallen

9,8102 gold badges39 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks! its working, the main key was in selecting foreign key along other columns, without foreign key it returns null, my mistake was that.