如何在SQL中对父记录中的记录进行排序

I have a table with columns "ItemId" and "ParentItemId". I want the results to be sorted in Parent-Child Order. with this, there are other columns on which the data needs to be sorted. I want the data to be sorted based on the "itemType" First.I have a table with columns "ItemId" and "Paren