select certain columns with from eloquent with relationship laravel 8 code example
Example 1: laravel eloquent get only field name
//Eloquent: Get specific columns (not all the row). Pluck returns an array.
Model::where('id', 1)->pluck('name', 'surname');
// If you only want to get the result value:
Model::where('id', 1)->value('name');
Example 2: laravel model particular column
Table::select('column1', 'column2')
->where('checker', 'value')
->get();