$resstate = Db::name('gametext')
->where([
'status'=>0,
'isEgg'=>0,])
->where('stage','>=',$stage)
->field("count(*) as count,stage")
->group("stage")
->whereTime('create_time', $timeperiod)
->select();这是查询出来的结果[{"count":10,"stage":15},{"count":10,"stage":16},{"count":10"stage":17},{"count":10,"stage":18}]第二张表查询： $resstate = Db::name('gametext_other')
->where([
'status'=>0,
'isEgg'=>0,])
->where('stage','>=',$stage)
->field("count(*) as count,stage")
->group("stage")
->whereTime('create_time', $timeperiod)
->select();这是查询出来的结果[{"count":20,"stage":15},{"count":20,"stage":16},{"count":20"stage":17},{"count":20,"stage":18}]请问如何用一个查询过程查询出两张表的合并结果[{"count":30,"stage":15},{"count":30,"stage":16},{"count":30"stage":17},{"count":30,"stage":18}] 最佳答案
