按天统计

select bf_card.card_num,bf_card.name,COUNT(DISTINCT uid,DATE_FORMAT(bf_kitchen_waste_order.created_at,'%Y-%m-%d')) from bf_kitchen_waste_order JOIN bf_card ON bf_card.id=bf_kitchen_waste_order.uid where bf_kitchen_waste_order.created_at BETWEEN '2019-08-01' AND '2019-11-01'and bf_card.id = 4465 GROUP BY bf_kitchen_waste_order.uid

 

 

 

TP5转成原生sql语句（fetchSql）

var_dump(Db::table('bf_uploads')->where($where) ->fetchSql()->select());