sql 查询商品，出价最低的

SELECT
	`g`.`goods_id`,
	`g`.`goods_name`,
	`bi`.`uid`,
	`bi`.`time`,
	`bi`.`price`,
	`u`.`nickname`
FROM
	`tp_bid` bi
INNER JOIN (
	SELECT
		goodsID,
		min(price) AS price
	FROM
		`tp_bid`
	GROUP BY
		goodsID
) AS ci ON bi.goodsID = ci.goodsID
AND bi.price = ci.price

LEFT JOIN `tp_users` `u` ON `u`.`user_id` = `bi`.`uid`
LEFT JOIN `tp_goods` `g` ON `g`.`goods_id` = `bi`.`goodsID`