people表：

person表：

SELECT * FROM person
LEFT JOIN people on people.id=person.id

查询的结果id(1)和name(1)说明列名重复

SELECT person.id,person.name,people.id as pid,people.name as pname FROM person
LEFT JOIN people on people.id=person.id

重复的列名起一个别名