mongodb多字段分组统计、多表联查脚本

 db.T_ZXJC_FQXSSJB.aggregate([
			{ $group: { _id: {"pwxkzbh":"$pwxkzbh","xkpfkwybm":"$xkpfkwybm","dwmc":"$dwmc","pfkmc":"$pfkmc"}, maxtime: { $max: '$data_time'},maxid:{$max:"$_id"} 
			} },		
			{ $lookup: {from: "T_ZXJC_FQXSSJB",	localField:"maxid",	foreignField:"_id",	as: "tb2"}},
			{ $project: { "_id": 0, "WrState":"$tb2.WrState","pwxkzbh":"$_id.pwxkzbh","xkpfkwybm":"$_id.xkpfkwybm","dwmc":"$_id.dwmc","pfkmc":"$_id.pfkmc" } }
		])