Filter a 2d array by a static value and a column in another 2d array

I have 2 arrays where they have some common id values, but the keys for these id keys differ slightly.

$comps = [
  [
    'c_id' => '123',
    'status' => 'active'
  ],
  [
    'c_id' => '456',
    'status' => 'destroyed'
  ],
  [
    'c_id' => '789',
    'status' => 'active'
  ]
];

$rests = [
  [
    'r_id' => 123,
    'extra' => 'some extra info for r_id 123'
  ],
  [
    'r_id' => 456,
    'extra' => 'some extra info for r_id 456'
  ]
];

My objective here is to return all entries of the $rests array that have corresponding entries within the $comps array that have both matching ID values and a status => active.

How can one achieve this?

I have seen and used array_uintersect() in the past, however I can't seem to get this to work in the desired way.

You can achive this with a nested foreach loop.

$matches = [];
foreach ($rests as $rest) {
    foreach ($comps as $comp) {
        if ($rest['r_id'] === $comp['c_id'] && $comp['status'] === 'active') {
            $matches[] = $rest;
        }
    }
}

print_r($matches);

Output

Array
(
    [0] => Array
        (
            [r_id] => 123
            [extra] => some extra info for r_id 123
        )

)