best way to comparison between tow table database in laravel code example
Example 1: comparison of two tables in laravel using model
$paidFeesIds = Fee::whereHas('paidFees', function($q) {
$q->where('payment_status', 1);
})->pluck('id')->toArray();
$notPaidFeesIds = Fee::whereNotIn('id', $paidFeesIds)->pluck('id')->toArray();
Example 2: comparison of two tables in laravel using model
public function paidFees()
{
return $this->hasMany(PaidFees::class, 'fee_id');
}