Data output left join Repository?

Question

Laravel

there is a model
User (name,email)
AND models UserAttribute (fullanme, birthday, city_id), UserService (premium,top) , City (name)

There is an interface

interface UserRepositoryContract
{
    public function getAllUsersWithPaginate($perPage);
}

repository UserRepository

class UserRepository implements UserRepositoryContract
{
    private $user;

    public function __construct($user)
    {
        $this->user = $user;
    }
}

how do i make a query with leftJoin to list all users with name,fullanme,city.name?

I can't figure out how to make this request in the repository

public function getAllUsers($perPage)
{
   
}

Answer 1

Use connections . Add user_id to UserAttribute/UserService, hasOne relationship

public function attributes()
{
    return $this->hasOne(UserAttribute::class);
}

UserAttribute bind to city

public function city()
{
  return $this->belongsTo(City::class);
}

Request

User::with('attributes.city', 'services')
    ->paginate($perPage);

But UserAttribute is an extra layer. It is better to remove these fields in User and write connections there.