php - 具有预加载的 Laravel 分组

Question

我想通过预加载实现一些分组

当我做这样的事情时:

$usersWithDepartments = User::with('department')->get();

结果是:

[
    {
        "userID": 491,
        "userName": "gigi"
        "deparment": 
        {
            "departmentID": 1,
            "name": "Economy"
        }
    },
    {
        "userID": 444,
        "userName": "gigi2"
        "deparment": 
        {
            "departmentID": 1,
            "name": "Economy"
        }
    }
]

但我想知道是否可以这样做:

$usersWithDepartments = User::with('department')->groupBy('deparment')->get();

为了获得这样的 JSON:

[
    {
        "departmentID": 1,
        "name": "Economy",
        "users":
        [
            {
                "userID": 491,
                "userName": "gigi"            
            },
            {
                "userID": 444,
                "userName": "gigi2"            
            }            
        ]
    }
]

我知道我可以做 Department::with('users') 但我想保留上面的相同查询以免进行另一个查询调用

如果不可能。还有其他解决方法吗？

Answer 1

是的，你可以做到这一点

$usersWithDepartments = User::with('department')->groupBy('departmentID');
     $usersWithDepartments->toJson();