代码之家 › 专栏 › 技术社区 › Roman Newaza

条令连接结果数据结构

doctrine symfony php

Roman Newaza · 技术社区 · 6 年前

使用此查询:

$qb = $this->createQueryBuilder('r');
$qb->leftJoin('r.users', 'u')
    ->addSelect('count(u.id) as user_count')
    ->groupBy('r.id');

我得到结果集:

Array
(
    [0] => Array
        (
            [0] => Array
                (
                    [id] => 45
                    [role_name] => ROLE_ADMIN
                    [description] => Admin roles
                )

            [user_count] => 1
        )

    [1] => Array
        (
            [0] => Array
                (
                    [id] => 47
                    [role_name] => ROLE_OPERATOR
                    [description] => Operator role
                )

            [user_count] => 1
        )

    [2] => Array
        (
            [0] => Array
                (
                    [id] => 48
                    [role_name] => ROLE_TEST
                    [description] => ROLE_TEST
                )

            [user_count] => 0
        )

)

有没有一种聪明的方法可以将所有属性转换为同一级别?现在,角色在子数组中,键为0。

期望结果:

Array
(
    [0] => Array
        (
            [id] => 45
            [role_name] => ROLE_ADMIN
            [description] => Admin roles
            [user_count] => 1
        )

    [1] => Array
        (
            [id] => 47
            [role_name] => ROLE_OPERATOR
            [description] => Operator role
            [user_count] => 1
        )

    [2] => Array
        (
            [id] => 48
            [role_name] => ROLE_TEST
            [description] => ROLE_TEST
            [user_count] => 0
        )

)