求2维数组整理合并成3维数组的方法

Question

-----表A-------------------------
aid     aaa
1       A内容
--------------------------------------表B-------------------------
bid    aid     bbb
1       1       B内容
2       1       B内容2
--------------------------------------表C-------------------------
cid    bid    aid    ccc
1      1       1      C内容
2      1       1      C内容2
3      2       1      C内容3
4      1       1      C内容4
5      2       1      C内容5
----------------------------------已知AID 
while(select bid,bbb from 表B where aid=1){
select cid,ccc from 表C where bid=表B.bid
}
这样做 如果表B aid=x的条数很多 ..那......所以
我想用另一种方法去做
select bid,bbb from 表B where aid=1
select cid,bid,ccc from 表C where aid=1
然后用 PHP 整理数组 把2个二维数组根据BID 变成3维数组
结果跟while的结果一样
不知道可不可以
求方法 

Answer 1

我想要的结果 是 这样的
Array
(
    [0] => Array
        (
            [bid] => 1
            [bbb] => b内容1
            [bc] => array(
[0] => Array(
[cid] => 1
                         [ccc] => c内容1
)
[1] => Array(
[cid] => 2
                         [ccc] => c内容2
)
[2] => Array(
[cid] => 4
                         [ccc] => c内容4
)
)
        )
 
    [1] => Array
        (
            [bid] => 2
            [bbb] => b内容2
            [bc] => array(
[0] => Array(
[cid] => 3
                         [ccc] => c内容3
)
[1] => Array(
[cid] => 5
                         [ccc] => c内容5
)
)
        )
 
)

Answer 2

Array
(
    [0] => Array
        (
            [bid] => 1
            [bbb] => b内容1
            [bc] => array(
                        [0] => Array(
                                [cid] => 1
                                [ccc] => c内容1
                                        )
                        [1] => Array(
                                [cid] => 2
                                [ccc] => c内容2
                                        )
                        [2] => Array(
                                [cid] => 4
                                [ccc] => c内容4
                                        )
                        )
        )    [1] => Array
        (
            [bid] => 2
            [bbb] => b内容2
            [bc] => array(
                        [0] => Array(
                                [cid] => 3
                                [ccc] => c内容3
                                        )
                        [1] => Array(
                                [cid] => 5
                                [ccc] => c内容5
                                        )
                        )
        ))