在Laravel中执行连接查询的更好方法

Question

Currently I have two tables; Users and Employees

All users are employees but not all employees are users,

I have a models Users and Employee, the personal details of a user are pulled his respective employee record.

Now I wanted to display all users and I can do it using User::all(); but also I wanted to have their personal details too.

currently I'm doing a DB:: call to join table in a function on my Users Model.

is there a better approach to this?

Answer 1

You can do it the Laravel way - eager load the relationship

$users = User::with('employee')->get();

This assumes that you have your relationships defined, at least on User side.

use Illuminate\Foundation\Auth\User as Authenticatable;
use App\Employee;

class User extends Authenticatable
{
    // ...

    public function employee()
    {
        return $this->hasOne(Employee::class, 'employee_no');
    }
}

FYI the Laravel way doesn't necessarily mean the fastest or the best way. It's usually syntactically more expensive/terse and convenient though.

Eager loading a relationship requires an additional query. In your case two queries will be executed under the hood and then employee property will be materialized for each User model in a collection.

So your way with a join and one roundtrip to the database might be more performant at the end of the day.