$start = strtotime(date('Y-m-d H:00:00',time()));
$end = strtotime(date('Y-m-d H:59:59',time()));
$arr = self::alias('ta')
->field('ta.goods_id,ta.grab_good_img_url,ta.id as task_id,ta.sid,ta.good_name,ta.remark,ta.good_url,
ta.good_img_url,ta.actual_price,ta.total_jian,ta.show_price,ta.stime,ta.etime,td.id as dan_id,td.keyword,
td.stime as dan_stime,td.etime as dan_etime,ta.gift_img,ta.type,ta.subsidy')
->join('__PDD_TASK_DAN__ td', 'ta.id=td.task_id')
->where('ta.id',$task_id)
->where('td.stime','>=',$start)
->where('td.etime','<=',$end)
->orderRaw('rand()') //orderRaw('rand()') 将查询结果的顺序随机打乱,使用find()取一条,实现随机取一条数据
->find();
生成的sql: