How correct is the following Eloquent/Laravel code?

Question

Laravel

There is a certain list which we receive from basis.
Let's call it a list of people.

protected function getPeoples($id) {
        $results = Peoples::all();
        return $results;
    }

Next, we need to get several elements that refer to one person:

protected function getCases($id) {
        $results = Cases::where('PeopleID', '=', $id)->get();
        return $results;
    }

And cases, in turn, also have several nested elements:

protected function getCases($id) {
        $results = Cases::where('PeopleID', '=', $id)->get();
        foreach ($results as $result) {
            $result->bills = Bills::where('CaseID', '=', $result->CaseID)->with('statuses')->get(array('BatchID'));
        }
        return $results;
    }

How true is the following and how to do with left join.
I sometimes find it easier to just use SQL than to convert the SQL to eloquent code.

Answer 1

Try to use has-many-through links to avoid extra request for bills.