Laravel - 获取所有记录，而不仅仅是第一个？

Question

today I am facing a problem with Laravel. What I want to do is get every 'stat' value for every record where government_type = higher_government. By the way, I am different types, but this is just one of many.

$higherGovernment = Cache::remember('government.higher_government', 1, function() {
    return GovernmentRole::where('government_type', 'higher_government')->first()->stats;
});

How can I get all the stats for all types instead of just calling ->first() ?

I have tried removing the ->first() but it doesn't do anything except give me this error:

Undefined property: Illuminate\Database\Eloquent\Builder::$stats

stats is a relationship by the way:

    public function stats(){
       return $this->hasMany('App\Database\Website\User\Roleplay', 'government_id');
   }

Answer 1

If you only want one column from this table, you can use the select function to indicate wich ones you want.

Like so:

<?php
    $higherGovernment = Cache::remember('government.higher_government', 1, function() {
        return GovernmentRole::where('government_type', 'higher_government')->select('stats')->get();
    });

The collection $higherGovernment will now contain GovernmentRole objects with one parameter, stats.

If you would like this to be an array of only the stats property, you can use collections to pluck this value out of it. Like so:

<?php
    $higherGovernment = Cache::remember('government.higher_government', 1, function() {
        return GovernmentRole::where('government_type', 'higher_government')->select('stats')->get()->pluck('stats');
    });

Update:

Now that we know that stats is a relation I think the best solution is to just load all GovernmentRole objects and eager load the relation. Then you can display the stats for every GovernmentRole.

You can do it like this:

<?php
    $higherGovernment = Cache::remember('government.higher_government', 1, function() {
        return GovernmentRole::where('government_type', 'higher_government')->with('stats')->get();
    });

    // Just an example on how to get the stats
    foreach ($g in $higherGovernment)
        echo $g->stats->count();