tb_Project表：
| ID | ProjectCreater | ProjectPrincipal | ... |
| 1 | 1 | 2 | ... |
tb_User表：
| ID | UserRealName |
| 1 | 张三 |
| 2 | 李四 |
select a.*,b.UserRealName as Creater,c.UserRealName as Principal from tb_Project a, tb_User b, tb_User c where a.ProjectCreater=b.ID and a.ProjectPrincipal=c.ID
结果：
tb_Project表：
| ID | ProjectCreater | ProjectPrincipal | ... | Creater | Principal |
| 1 | 1 | 2 | ... | 张三 | 李四 |
原文：http://www.cnblogs.com/liuswi/p/3615141.html