从第二个数组中获取数据并将值放入数组1中

Question

I have the following situation and cannot find an easy way to do it.

I have 2 arrays:

1)

Array (
[0] => Array
    (
        [FirstName] => Tom
        [LastName] => Siemens
        [Id] => 10300
    )

[1] => Array
    (
        [FirstName] => Sam
        [LastName] => Tailor
        [Id] => 10301
    )

2)

Array
    (
    [0] => Array
           (
            [Type] => Invoice
            [Number] => 6344394
            [Project] => Array
                (
                    [Name] => Test Project 1
                    [ResponsibleUserId] => 10300
                    [Id] => 498
                    [ResponsibleUser] => 
                )

        )
    [1] => Array (
            [Type] => Invoice
            [Number] => 6345555
            [Project] => Array
                (
                    [Name] => Test Project 2
                    [ResponsibleUserId] => 10301
                    [Id] => 499
                    [ResponsibleUser] => 
                )

        )

What could be the best approach to get the "FirstName LastName" from the first array depends on the ID which must equal the Project Id from the second array and to put these values inside the second array -> Project -> ResponsibleUser?

The result I'm looking for is the following:

Final Array)

Array (
    [0] => Array
           (
            [Type] => Invoice
            [Number] => 6344394
            [Project] => Array
                (
                    [Name] => Test Project 1
                    [ResponsibleUserId] => 10300
                    [Id] => 498
                    [ResponsibleUser] => Tom Siemens
                )

        )
    [1] => Array (
            [Type] => Invoice
            [Number] => 6345555
            [Project] => Array
                (
                    [Name] => Test Project 2
                    [ResponsibleUserId] => 10301
                    [Id] => 499
                    [ResponsibleUser] => Sam Tailor
                )

        )

Answer 1

If you start by indexing the first array by the id using array_column() ...

$idList = array_column($array1, null, "Id");

You can then just loop over the second array and pick out the name each time and update it...

foreach (array2 as &$project ) {
    $id = $project["Project"]["ResponsibleUserId"];
    $project["Project"]["ResponsibleUser"] = $idList[$id]["FirstName"]." ".$idList[$id]["LastName"];
}

Use &$project as this allow you to update the original value which is what your after.