$field=[
"mvoucherorder.ID",
"ifnull(ifnull(acard.fdcName,acard.fdcNick),CONCAT(acard.fdcNo,'(未关注会员)')) as fdcNick",
"mvoucherorder.fddDateU",
"acard.fdcImage"
];
$data = M('mvoucherorder')->where($where)->join($join)->limit(($page-1)*$num,$num)->field($field)->select();
"mvoucherorder.ID",
"ifnull(ifnull(acard.fdcName,acard.fdcNick),CONCAT(acard.fdcNo,'(未关注会员)')) as fdcNick",
"mvoucherorder.fddDateU",
"acard.fdcImage"
];
$data = M('mvoucherorder')->where($where)->join($join)->limit(($page-1)*$num,$num)->field($field)->select();