Laravel how to add new field in query result

2019-02-09 20:32发布

问题:

How can I add new field in each item, I have used put() but it only add on the last item.

return self::where('latest', 1)
            ->where('competitionId',$competitionId)
            ->orderBy('won','desc')
            ->orderBy('teamName','asc')
            ->get(['teamName','played','won','lost','percentage', 'streak'])
            ->put('test', ['123', '345'])
            ->toJson();

Result:

{
"0": {"teamName": "A"},
"1": {"teamName": "B"},
"2": {"teamName": "C", "test": ['123', '345']},
}

Expected output:

{
"0": {"teamName": "A", "test": "qwerty"},
"1": {"teamName": "B", "test": "qwerty"},
"2": {"teamName": "C", "test": "qwerty"},
}

回答1:

you can use map()

->map(function ($item) {
  $item['test'] = ['123', '345'];
  return $item;
});