使用FOR JSON PATH创建嵌套的JSON数组

使用FOR JSON PATH创建嵌套的JSON数组

您可以使用以下查询：

SELECt pr.person_id AS [person.id], pr.person_name AS [person.name],    (        SELECT pt.pet_id AS id, pt.pet_name AS name         FROM @Pets pt WHERe pt.pet_owner=pr.person_id         FOR JSON PATH    ) AS [person.pet]FROM @Persons pr FOR JSON PATH, ROOT('pet owners')