Group database records

array-group-by-adv.php

<?php

$resources = array(
    [
        'parent_id' => 1,
        'parent' => 'Account',
        'module_id' => 11,
        'module' => 'User',
        'enabled' => true,
    ],
    [
        'parent_id' => 1,
        'parent' => 'Account',
        'module_id' => 12,
        'module' => 'User Role',
        'enabled' => false,
    ],
    [
        'parent_id' => 2,
        'parent' => 'Asset',
        'module_id' => 21,
        'module' => 'Device',
        'enabled' => true,
    ],
    [
        'parent_id' => 2,
        'parent' => 'Asset',
        'module_id' => 22,
        'module' => 'People',
        'enabled' => true,
    ],
    [
        'parent_id' => 2,
        'parent' => 'Account',
        'module_id' => 23,
        'module' => 'Modules',
        'enabled' => false,
    ],
);

$components = [];

foreach($resources as $resource) {
    
    $parent_idx = array_search($resource['parent_id'], array_column($components, 'id'));
    
    if(is_numeric($parent_idx)) {
        $module = array(
            'id' => $resource['module_id'],
            'name' => $resource['module'],
            'enabled' => $resource['enabled'],
        );
        
        $components[$parent_idx]['modules'][] = $module;
        continue;
    } 
    
    $component = array(
        'id' => $resource['parent_id'],
        'name' => $resource['parent'],
    );

    $module = array(
        'id' => $resource['module_id'],
        'name' => $resource['module'],
        'enabled' => $resource['enabled'],
    );

    $component['modules'][] = $module;

    $components[] = $component;
}

print json_encode(['components' => $components]);