是否在SQL Server中缩进FOR XML路径中的子类别？

ProductID  |  ProductName   |  CategoryID
-----------|----------------|-------------
1          |  Product 1     |  1
2          |  Product 2     |  1
3          |  Product 3     |  2

SELECT CategoryID AS 'Category/@ID',
       (SELECT ProductID, ProductName
        FROM Products AS P
        WHERE P.CategoryID = C.CategoryID
        FOR XML PATH('Product'), TYPE)
FROM Products AS C
GROUP BY CategoryID
FOR XML PATH('Category'), ROOT('Categories'), ELEMENTS XSINIL

<Categories>
  <Category ID="1">
    <Product>
      <ProductID>1</ProductID>
      <ProductName>Product 1</ProductName>
    </Product>
    <Product>
      <ProductID>2</ProductID>
      <ProductName>Product 2</ProductName>
    </Product>
  </Category>
  <Category ID="2">
    <Product>
      <ProductID>3</ProductID>
      <ProductName>Product 3</ProductName>
    </Product>
  </Category>
</Categories>