help getting child category into a db

[tryingtolearn]

I have the following result that I am getting from a source.

 

SimpleXMLElement Object
(
    [CategoryID] => 1
    [Name] => Other
    [Order] => 0
    [link] => http://www.link.com?sub=1
)

SimpleXMLElement Object
(
    [CategoryID] => 1233916011
    [Name] => ceramic 
    [Order] => 1
    [ChildCategory] => SimpleXMLElement Object
        (
            [CategoryID] => 1234016011
            [Name] => dish
            [Order] => 1
        )

    [link] => http://www.link.com?sub=13476
)

SimpleXMLElement Object
(
    [CategoryID] => 1233917011
    [Name] => laminate
    [Order] => 2
    [link] => http://www.link.com?sub=98247
)

I need to get it into a database with the following structure

 

id  categoryID  cName  cOrder  clink  cparent

 

 

By using

foreach($this->resp->Store->CustomCategories->CustomCategory as $cat) {
	$sub = $cat->CategoryID;
	$ord = $cat->Order;
	$linkto = "$stlink?fsub=$fsub";
	$nm = htmlspecialchars($cat->Name);
	$par=$cat->ChildCategory->Order;
	$query = "INSERT INTO Cat (categoryID,cName,cOrder,clink,cparent) VALUES ('$sub','$nm','$ord','$linkto','$par')";		
	$result = @mysql_query ($query); // Run the query.
	}

 

I can get

id   categoryID   cName   cOrder  clink                          cparent
1    1            Other   0       http://www.link.com?sub=1      0
2    1233916011   ceramic 1       http://www.link.com?sub=13476  0
2    1233917011   laminate 2      http://www.link.com?sub=98247  0

 

But I need to get the ChildCategory in there w/ cparent like

id   categoryID   cName   cOrder  clink                          cparent
1    1            Other   0       http://www.link.com?sub=1      0
2    1233916011   ceramic 1       http://www.link.com?sub=13476  0
3    1234016011   dish    1                                      1  <--- like this
4    1233917011   laminate 2      http://www.link.com?sub=98247  0

 

any help appreciated...