树形数组 php,请问php然后把树形数组回溯成一维数组?

现有树形数组结构如下

需要把它回溯成一维数组以插入数据库

需要一维数组结构如下

array(

1 => array('id'=>'1','parentid'=>0),

2 => array('id'=>'2','parentid'=>0),

3 => array('id'=>'3','parentid'=>1),

4 => array('id'=>'4','parentid'=>1),

5 => array('id'=>'5','parentid'=>2),

6 => array('id'=>'6','parentid'=>3),

7 => array('id'=>'7','parentid'=>3)

);

我写成这样但不是想要的结果，求大佬更改，谢谢

private function _getOrderData($datas)

{

$_data = [];

static $i = 0;

foreach ($datas as $data) {

$i++;

$rows = ['id' => $data['id'], 'pid' => isset($data['children']) ? $data['id'] : 0, 'menu_order' => $i];

if(isset($data['children'])) {

$this->_getOrderData($data['children']);

}

$_data[] = $rows;

}

return $_data;

}

3Q