BaseModel.php

<?php

abstract class BaseModel extends Model
{

/**
     * Находит последнюю запись для значений определенного поля.
     *
     * Т.е. с групировкой по указанному полю.
     *
     * @param Builder|QueryBuilder $query
     * @param string $column
     * @param array $values
     * @param string $date
     * @return Builder|QueryBuilder
     */
    public function scopeLastFor($query, $column, array $values = [], $date = 'created_at', $mergeWheres = true)
    {
        if (!empty($values)) {
            $query->whereIn($column, $values);
        }

        $sub_query = static::select("{$column} AS __{$column}")->selectRaw("MAX({$date}) as __{$date}")->groupBy($column);

        if ($mergeWheres) {
            $sub_query->mergeWheres($query->getQuery()->wheres, $query->getQuery()->getBindings());
            $query->getQuery()->mergeBindings($sub_query->getQuery());
        }

        $query->join(new Expression("({$sub_query->toSql()}) as last_for_t"), function ($join) use ($column, $date) {
            $join->on("last_for_t.__{$column}", '=', $column)
                ->on("last_for_t.__{$date}", '=', $date);
        });

        return $query;
    }
}