SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

5 rows affected

SELECT
    main.claimId,
    main.disputeId,
    'CREAR_NC' AS disputeType,
    'OK' AS status,
    'Aprobador' AS description,
    (
        SELECT
            '[' + STUFF(
                (
                    SELECT
                        ', ' + (
                            SELECT '{"mail": "' + sub.approverEmail + '", "approvalLevel": ' + CAST(sub.approvalLevel AS VARCHAR) + '}'
                            FOR XML PATH(''), TYPE
                        ).value('.', 'VARCHAR(MAX)')
                    FROM InvoiceDisputesApprovalResult AS sub
                    WHERE sub.claimId = main.claimId 
                          and sub.disputeId = main.disputeId 
                    FOR XML PATH('')
                ), 1, 2, ''
            ) + ']'
    ) AS approvers,
    NULL AS pvp,
    NULL AS salePrice,
    NULL AS saleMKUP,
    NULL AS claimMKUP,
    NULL AS mktope,
    NULL AS mkcliete
FROM InvoiceDisputesApprovalResult AS main
WHERE main.status = 'waiting' 
      AND main.disputeId = 3123123 
GROUP BY main.claimId, main.disputeId;

claimId	disputeId	disputeType	status	description	approvers	pvp	salePrice	saleMKUP	claimMKUP	mktope	mkcliete
3423	3123123	CREAR_NC	OK	Aprobador	[{"mail": "approver1@mailinator.com", "approvalLevel": 1}, {"mail": "approver2@mailinator.com", "approvalLevel": 2}, {"mail": "approver3@mailinator.com", "approvalLevel": 3}]	null	null	null	null	null	null