您可以使用以下查询：
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')
