$sql = "select O.actor_user,O.game_id,C.option_id,sum(C.num)as numbers from gift_order as O ? ? ? ?left join gift_card_option as C on O.id = C.order_id ? ? ? ?where O.state = 1 ? ? ? ?and O.created_date>'2017-08-11 0:0:0' ? ? ? ?and O.created_date<'2017-08-11 11:40:08' ? ? ? ?group by O.actor_user,O.game_id,C.option_id limit 0,30";能用php和或者優化sql ? ?求大神幫忙 謝謝