I have a table looking like this:

id	name			parent  
1	Category 1		0 
2 	Category 2		0 
3 	Category 3		0 
4 	Subcategory 1.1		1 
5 	Subcategory 1.2		1 
6	Subcategory 2.1		2
7	Subcategory 2.2		2

But can I view it like this? and if yes, how?:

id	name			parent
1	Category 1		0 
4 	Subcategory 1.1		1 
5 	Subcategory 1.2		1 
2 	Category 2		0
6	Subcategory 2.1		2
7	Subcategory 2.2		2