Add "computed attributes" support to Eloquent models

User.php

<?php

namespace App;

use App\Scopes\WithSelects;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;

class User extends Authenticatable
{
    use Notifiable, WithSelects;

    protected $casts = [
        'last_login_date' => 'datetime',
    ];

    public function selectLastLoginDate()
    {
        return Login::select('created_at')->whereRaw('user_id = users.id')->latest();
    }
}

users.blade.php

<table>
    <thead>
        <tr>
            <th>Name</th>
            <th>Last Login</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($users as $user)
            <tr>
                <td>{{ $user->name }}</td>
                <td>
                    @if ($user->last_login_date)
                        {{ $user->last_login_date->toDayDateTimeString() }}
                    @else
                        Never logged in
                    @endif
                </td>
            </tr>
        @endforeach
    </tbody>
</table>

UsersController.php

<?php

namespace App\Http\Controllers;

use App\User;

class UsersController extends Controller
{
    public function index()
    {
        return view('users')->withUsers(
            User::withSelects('last_login_date')->orderBy('last_name')->get()
        );
    }
}

WithSelects.php

<?php

namespace App\Scopes;

use Illuminate\Database\Eloquent\Builder as EloquentBuilder;
use Illuminate\Database\Query\Builder as QueryBuilder;

trait WithSelects
{
    public function scopeWithSelect($query, ...$selects)
    {
        $this->scopeWithSelects($query, ...$selects);
    }

    public function scopeWithSelects($query, ...$selects)
    {
        if (is_null($query->getQuery()->columns)) {
            $query->select('*');
        }

        foreach (array_flatten($selects) as $name) {
            $subQuery = $this->getModel()->{camel_case('select_'.$name)}();

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

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

            $query->selectSub($subQuery, $name);
        }
    }
}