Get most recent status for each server in laravel

I am using eloquent query builder and I am trying to get the most recent status for each server, I have a servers table that has a one to many relationship with my server_statuses table. My current 'solution' is based off the laracon online advanced eloquent presentation, but it is not returning anything from my database, attached below is my Server model, AppServiceProvider, and Controller.

What am I doing wrong here? I cant seem to figure it out.

Controller:

$recent = Server::WithLastStatusDate()
            ->OrderBy('server_id');

Model:

public function scopeWithLastStatusDate($query){

    $query ->addSubSelect('last_status_date', ServerStatus::select('created_at')
        ->whereRaw('server_id = servers.id')
        ->latest()
    );
}

AppServiceProvider:

Builder::macro('addSubSelect', function ($column, $query) {
    if (is_null($this->getQuery()->columns)) {
        $this->select($this->getQuery()->from.'.*');
    }

    return $this->selectSub($query->limit(1)->getQuery(), $column);
});

Again any help would be much appreciated, Thank you for your time!

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2lDZCs5
via IFTTT