Laravel Model joins

User::query()->joinMany(Transaction::class);

Installation

You can install the package via composer:

composer require joelharkes/laravel-model-joins

Usage

examples:

User::query()->joinMany(Transaction::class);
$post->user()->joinMany(Transaction::query()->withoutTrashed());
Transaction::query()->joinOne(User::class, type: 'left');
Transaction::query()->joinOne(User::query()->where('is_manager', true));

types of joins

Join a one-to-many relationship:

User::query()->joinMany(Transaction::class);

Join a x-to-one relationship:

Transaction::query()->joinOne(User::class);

All of these work well with SoftDeletes no matter if you join left, write or inner.

Join queries

Transaction::query()
    ->joinOne(User::query()->where('is_manager', true));