用foreach循环去取数据库的值,并合并数组

$list = $mTrans->alias('a')
    ->join('mpp_biz_time b','a.channel_id=b.id')
    ->field('a.down_sn,a.success_time,a.amount,a.fee,a.acc_no,b.title')
    ->where(['a.status' => '2'])
    ->where(['a.member_id' => $member_id])
    ->where('a.success_time', 'between', [strtotime($mtime[0]), strtotime($mtime[1] . ' 23:59:59')])
    ->order('a.success_time desc')
    ->select();
$list_all = json_decode(json_encode($list,JSON_UNESCAPED_UNICODE ),ture);
if (empty($list)) {
    $this->EchoJson('0', '查询成功');
}
foreach ($list_all as $k=>$v) {
    $sn[]=$v['sn'];
    $acc_no[]=$v['acc_no'];
    $info[] = Loader::model('admin/Cardbintb')
        ->field('bank_name,logo')
        ->where('card_len', strlen($v['acc_no']))
        ->where('bin = SUBSTRING(:card_no, 1, bin_len)', ['card_no' => $v['acc_no']])
        ->find()->toArray();
    if (empty($temp[$v['date']])) {
        $temp[$v['date']]['total'] = $v['amount'];
    } else {
        $temp[$v['date']]['total'] += $v['amount'];
    }
    $mtotal += $v['amount'];
}
$arr = array();
foreach($list_all as $k=>$r){
    $arr[] = array_merge($r,$info[$k]);
}

数组类型$list_all

array(3) {
  [0]=>

  array(6) {

    ["down_sn"]=>

    string(24) "318031210214511700000823"

    ["success_time"]=>

    int(1520821445)

    ["amount"]=>

    string(6) "100.00"

    ["fee"]=>

    string(4) "4.42"

    ["acc_no"]=>

    string(16) "4581231314"

    ["title"]=>

    string(20) "银联无卡快捷T1"

  }

  [1]=>

  array(6) {

    ["down_sn"]=>

    string(24) "318031210200963800000822"

    ["success_time"]=>

    int(1520821269)

    ["amount"]=>

    string(6) "100.00"

    ["fee"]=>

    string(4) "4.42"

    ["acc_no"]=>

    string(16) "4581231314"

    ["title"]=>

    string(20) "银联无卡快捷T1"

  }

  [2]=>

  array(6) {

    ["down_sn"]=>

    string(24) "318031209553686800000821"

    ["success_time"]=>

    int(1520820954)

    ["amount"]=>

    string(6) "100.00"

    ["fee"]=>

    string(4) "4.42"

    ["acc_no"]=>

    string(16) "4581231314"

    ["title"]=>

    string(20) "银联无卡快捷T1"

  }
}
循环取数据库的值$info
array(3) {
  [0]=>
  array(2) {
    ["bank_name"]=>
    string(12) "交通银行"
    ["logo"]=>
    int(5)
  }
  [1]=>
  array(2) {
    ["bank_name"]=>
    string(12) "交通银行"
    ["logo"]=>
    int(5)
  }
  [2]=>
  array(2) {
    ["bank_name"]=>
    string(12) "交通银行"
    ["logo"]=>
    int(5)
  }
}最终数据合集
{
    "errcode": 0,
    "msg": "查询成功",
    "data": {
        "list": [
            {
                "down_sn": "318031210214511700000823",
                "success_time": 1520821445,
                "amount": "100.00",
                "fee": "4.42",
                "acc_no": "4581231314",
                "title": "银联无卡快捷T1",
                "bank_name": "交通银行",
                "logo": 5
            },
            {
                "down_sn": "318031210200963800000822",
                "success_time": 1520821269,
                "amount": "100.00",
                "fee": "4.42",
                "acc_no": "4581231314994443",
                "title": "银联无卡快捷T1",
                "bank_name": "交通银行",
                "logo": 5
            },
            {
                "down_sn": "318031209553686800000821",
                "success_time": 1520820954,
                "amount": "100.00",
                "fee": "4.42",
                "acc_no": "4581231314",
                "title": "银联无卡快捷T1",
                "bank_name": "交通银行",
                "logo": 5
            }
        ],
    }
}