Eloquent addSubSelect()

AppServiceProvider.php

<?php

use Illuminate\Database\Eloquent\Builder as EloquentBuilder;
use Illuminate\Database\Query\Builder as QueryBuilder;
use Illuminate\Database\Query\Expression;
use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    public function boot()
    {
        QueryBuilder::macro('addSubSelect', function ($field, $callback) {
            $query = $callback();

            if (is_null($this->columns)) {
                $this->select($this->from.'.*');
            }

            if ($query instanceof EloquentBuilder) {
                $query = $query->getQuery();
            }

            if ($query instanceof QueryBuilder) {
                $query = $query->limit(1);
            }

            if ($query instanceof Expression) {
                $query = $query->getValue();
            }

            $this->selectSub($query, $field);
        });
    }
}

User.php

<?php

class User extends Model
{
    protected $casts = [
        'last_login_date' => 'datetime',
    ];

    public function scopeSelectLastLoginDate($query)
    {
        $query->addSubSelect('last_login_date', function () {
            return Login::select('created_at')
                ->whereRaw('user_id = users.id')
                ->latest();
        });
    }
}

UsersController.php

<?php

class UsersController extends Controller
{
    public function index()
    {
        return view('users.index')->withUsers(
            User::selectLastLoginDate()->orderBy('last_name')->paginate()
        );
    }
}