1. 根据一张表中的两个字段拿另外一张表中的同一个字段的查询
SELECT
p.name,
u1. name AS createName,
u2. name AS managerName
FROM
project AS p
INNER JOIN user AS u1ON p.create_by = u1.id
INNER JOIN user AS u2 ON p.manager_id = u2.id
project 表中的“create_by“ 和 “manager_id ” 同时对应的user表中name.