How to write the below N1QL

SQL++
,
1

I have the below Query that gives the following results

select c.uuid as companyId,
c.data.companyName as companyName,
c.data.admins as owners, 
p.uuid as partnerAppId,
p.appName as partnerAppName, 
p.data.additionalAdmins as admins ,
p.data.additionalDevelopers as developers 
from
api_external as c 
left Join 
api_external as p on 
c.uuid = p.data.companyId
where c.type ="company" and c.uuid  ="087701a9fdeb463b9d814476923d1e6c"
and p.type = "partnerApp"  and ( p.data.additionalAdmins is not null or  p.data.additionalDevelopers is not null )
and p.backupOf is null and c.backupOf is not null


[
  {
    "admins": null,
    "companyId": "087701a9fdeb463b9d814476923d1e6c",
    "companyName": "ABC",
    "developers": [
      "04abad271e084c188dc288a1b22bafa3"
    ],
    "owners": [
      "3cb1181fea564e2cb9b8bf65db1a5ac5",
      "1461786d798b4310a23e6ff27a3754bd",
      "174f181517474eac8ba8983d8d05429f",
      "1b7abc43b2c2486ebede19a172701655"
    ],
    "partnerAppId": "248847cdd7e8410fb26147ced60ad0b2"
  },
  {
    "admins": [
      "1b097c6cea01492db36828e41fc101d1"
    ],
    "companyId": "087701a9fdeb463b9d814476923d1e6c",
    "companyName": "ABC",
    "developers": [
      "04abad271e084c188dc288a1b22bafa3"
    ],
    "owners": [
      "3cb1181fea564e2cb9b8bf65db1a5ac5",
      "1461786d798b4310a23e6ff27a3754bd",
      "174f181517474eac8ba8983d8d05429f",
      "1b7abc43b2c2486ebede19a172701655"
    ],
    "partnerAppId": "8fe3fb5e520c4e84b67154a914ccd46a"
  }
]

But i want result in this form -
Since company details r needed only once it should come once
Since we can have multiple partners it should come in as a subsection ,
How to change the select Query

{
  "companyId": "087701a9fdeb463b9d814476923d1e6c",
  "owners": [
    "3cb1181fea564e2cb9b8bf65db1a5ac5",
    "1461786d798b4310a23e6ff27a3754bd",
    "174f181517474eac8ba8983d8d05429f",
    "1b7abc43b2c2486ebede19a172701655"
  ],
  "companyName": "ABC",
  "partnerDetails": [
    {
      "admins": null,
      "developers": [
        "04abad271e084c188dc288a1b22bafa3"
      ],
      "partnerAppId": "248847cdd7e8410fb26147ced60ad0b2"
    },
    {
      "admins": [
        "1b097c6cea01492db36828e41fc101d1"
      ],
      "developers": [
        "04abad271e084c188dc288a1b22bafa3"
      ],
      "partnerAppId": "8fe3fb5e520c4e84b67154a914ccd46a"
    }
  ]
}
2 
SELECT c.uuid AS companyId,
       c.data.companyName AS companyName,
       c.data.admins AS owners,
       (SELECT p.uuid AS partnerAppId, p.appName AS partnerAppName,
               p.data.additionalAdmins AS admins , p.data.additionalDevelopers AS developers
        FROM api_external AS p
        WHERE p.type = "partnerApp"
              AND p.data.companyId = c.uuid
              AND p.backupOf IS NULL
              AND (p.data.additionalAdmins IS NOT NULL OR p.data.additionalDevelopers IS NOT NULL )
       ) AS partnerDetails
FROM api_external AS c
WHERE c.type ="company"
      AND c.uuid  = "087701a9fdeb463b9d814476923d1e6c"
      c.backupOf IS NOT NULL;

remove correlation one can also do this
p.data.companyId = “087701a9fdeb463b9d814476923d1e6c”