搜索 |
$myuser=M("User");
$datainfo=$myuser
->alias('u')
->field("u.name,d.name AS bumenm,c.name as gongduan")
->join("LEFT JOIN __DEPARTMENT__ d ON u.bumen=d.id")
->join("LEFT JOIN __DEPARTMENT__ c ON u.gongduan=c.id")
->select();