$subQuery = $model->order('purchase_time desc')->buildSql();
$list = M('asset as ass')
->table($subQuery .'as ass')
->join('asset_class as ac on ac.id=ass.asset_classid')
->field('ass.*,sum(ass.goods_count) as sum_goods_count,ac.asset_classname')
->where($where)->group('ass.goods_name')->select();
$list = M('asset as ass')
->table($subQuery .'as ass')
->join('asset_class as ac on ac.id=ass.asset_classid')
->field('ass.*,sum(ass.goods_count) as sum_goods_count,ac.asset_classname')
->where($where)->group('ass.goods_name')->select();