如何修改laravel中eloquent返回的数组结构

Question

我目前在运行 Bonus::with('users')->get() 时得到以下数组结构我曾尝试添加数组并合并类似的键，但它不起作用。我尝试使用 laravel 中提供的辅助方法，但似乎无法使其正常工作。[{"id": 1,"users_id": 1,"bonus_type_id": 1,"is_paid": 0,"amount": "100.00","description": "desc","note": null,"created_by": 2,"last_modified_by": null,"created_at": null,"updated_at": null,"deleted_at": null,"user": {"id": 1,"name": "test","email": "[e-mail]","email_verified_at": null,"status": 1,"created_at": "2019-07-18 11:41:35","updated_at": "2019-07-18 11:41:35","deleted_at": null}},{"id": 2,"users_id": 1,"bonus_type_id": 2,"is_paid": 0,"amount": "100.00","description": "desc","note": null,"created_by": 2,"last_modified_by": null,"created_at": null,"updated_at": null,"deleted_at": null,"user": {"id": 1,"name": "test","email": "[e-mail]","email_verified_at": null,"status": 1,"created_at": "2019-07-18 11:41:35","updated_at": "2019-07-18 11:41:35","deleted_at": null}},{"id": 3,"users_id": 2,"bonus_type_id": 2,"is_paid": 1,"amount": "100.00","description": "desc","note": null,"created_by": 2,"last_modified_by": null,"created_at": null,"updated_at": null,"deleted_at": null,"user": {"id": 1,"name": "another test","email": "[e-mail]","email_verified_at": null,"status": 1,"created_at": "2019-07-18 11:41:35","updated_at": "2019-07-18 11:41:35","deleted_at": null}}]我希望结果是这样的[  {    user_id: 1,    name: "test",    bonuses: [      {        bonus_type_id: 1,        amount: 100,        is_paid: 0,      },      {        bonus_type_id: 2,        amount: 100,        is_paid: 0,      }    ],  },  {    user_id: 2,    name: "another",    bonuses: [      {        bonus_type_id: 2,        amount: 100,        is_paid: 1,      },    ]  }]

Answer 1

你需要改变你雄辩的关系。在模型内部为奖金表定义hasMany关系函数并使用它来获得所需的结果，如下所示：bonusesUser

User::with('bonuses')->get();

这样它将从用户表返回结果并为每个用户填充奖金。

说得通？

Answer 2

您可以使用 select 子查询获取特定信息，如果您的关系设置正确，这应该可以工作。

User::select('user_id','name','bonus_id')

    ->with(array('bonuses'=> function($query){

         $query->select('bonus_type_id','amount','is_paid');

    }))->get();