就是多個1級分類 下面有不確定個二級分類 二級分類下面有不確定個三級分類 我想獲取到相關的數據組合寫入數據庫 但是這個格式不知道怎么排才能獲取到對的數據

有空的親們給看看 幫下 謝謝

有沒有辦法獲取整列的值 然后根據長度去區分2列 然后再區分三列

現在獲取到的數據格式是按行的 1 2 3 。。。

上圖

上打印的數據

array (size=16)

0 =>

array (size=7)

0 => float 1

1 => string '銷售部' (length=9)

2 => string '銷售1區' (length=10)

3 => string '銷售1科室' (length=13)

4 => null

5 => null

6 => null

1 =>

array (size=7)

0 => float 2

1 => null

2 => null

3 => string '銷售2科室' (length=13)

4 => null

5 => null

6 => null

2 =>

array (size=7)

0 => float 3

1 => null

2 => null

3 => string '銷售3科室' (length=13)

4 => null

5 => null

6 => null

3 =>

array (size=7)

0 => float 4

1 => null

2 => null

3 => string '銷售4科室' (length=13)

4 => null

5 => null

6 => null

4 =>

array (size=7)

0 => float 5

1 => null

2 => string '銷售2區' (length=10)

3 => string '銷售1科室' (length=13)

4 => null

5 => null

6 => null

5 =>

array (size=7)

0 => float 6

1 => null

2 => null

3 => string '銷售2科室' (length=13)

4 => null

5 => null

6 => null

6 =>

array (size=7)

0 => float 7

1 => null

2 => null

3 => string '銷售3科室' (length=13)

4 => null

5 => null

6 => null

7 =>

array (size=7)

0 => float 8

1 => null

2 => null

3 => string '銷售4科室' (length=13)

4 => null

5 => null

6 => null

8 =>

array (size=7)

0 => float 9

1 => string '市場部' (length=9)

2 => string '市場1區' (length=10)

3 => string '市場1科室' (length=13)

4 => null

5 => null

6 => null

9 =>

array (size=7)

0 => float 10

1 => null

2 => null

3 => string '市場2科室' (length=13)

4 => null

5 => null

6 => null

10 =>

array (size=7)

0 => float 11

1 => null

2 => null

3 => string '市場3科室' (length=13)

4 => null

5 => null

6 => null

11 =>

array (size=7)

0 => float 12

1 => null

2 => null

3 => string '市場4科室' (length=13)

4 => null

5 => null

6 => null

12 =>

array (size=7)

0 => float 13

1 => null

2 => string '市場2區' (length=10)

3 => string '市場1科室' (length=13)

4 => null

5 => null

6 => null

13 =>

array (size=7)

0 => float 14

1 => null

2 => null

3 => string '市場2科室' (length=13)

4 => null

5 => null

6 => null

14 =>

array (size=7)

0 => float 15

1 => null

2 => null

3 => string '市場3科室' (length=13)

4 => null

5 => null

6 => null

15 =>

array (size=7)

0 => float 16

1 => null

2 => null

3 => string '市場4科室' (length=13)

4 => null

5 => null

6 => null