/*
* 声明了一个变量 (@i:=@i+1) sort 作为序号
* 每次执行查询语句获取结果后重置为0,在表名后用逗号分割下使用 (SELECT @i:=0) AS i
*/
SELECT (@i:=@i+1) sort,gr.region_title,g.goods_id,g.goods_name FROM `think_goods` g
LEFT JOIN `think_goods_region` gr on gr.id=g.region_id,(SELECT @i:=0) AS i
WHERE g.status=1 ADN g.is_del=0
ORDER BY g.region_id;
返回的结果如下: