当两列来自相同的id时，Laravel 3向旋转

$users = DB::table('users')
            ->join('user_roles', 'users.id', '=', 'user_roles.user_id')
            ->select('users.id', 'users.name', 'user_roles.role')
            ->get();

$rotatedData = [];
foreach ($users as $user) {
    $id = $user->id;
    $name = $user->name;
    $role = $user->role;

    if (!isset($rotatedData[$id])) {
        $rotatedData[$id] = [
            'id' => $id,
            'name' => $name,
            'roles' => [],
        ];
    }

    $rotatedData[$id]['roles'][] = $role;
}

// 输出旋转后的数据
foreach ($rotatedData as $data) {
    echo "ID: " . $data['id'] . "\n";
    echo "Name: " . $data['name'] . "\n";
    echo "Roles: " . implode(', ', $data['roles']) . "\n";
    echo "\n";
}