您可以将别名添加到字段：
SELECt a.id, a.name, a.category_id, b.id AS catId, b.name AS catNameFROM product AS aLEFT JOIN category AS b ON a.category_id = b.category.id
您可以将别名添加到字段：
SELECt a.id, a.name, a.category_id, b.id AS catId, b.name AS catNameFROM product AS aLEFT JOIN category AS b ON a.category_id = b.category.id
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
