SELECT list is not in GROUP BY clause and contains nonaggregated
column 'xxxx' which is not functionally dependent on columns in GROUP BY clause;
this is incompatible with sql_mode=only_full_group_by
原因:mysql5.6和5.7兼容问题
解决方法:
sql_mode=“ONLY_FULL_GROUP_BY” 把这个去掉