如何编写postgresql查询来构建这样的json输出？

SELECT json_build_object(
    'id', id,
    'name', name,
    'email', email,
    'address', json_build_object(
        'street', address_street,
        'city', address_city,
        'state', address_state,
        'zip', address_zip
    ),
    'phone_numbers', json_agg(
        json_build_object(
            'type', phone_type,
            'number', phone_number
        )
    )
) AS json_output
FROM users
GROUP BY id, name, email, address_street, address_city, address_state, address_zip;