4,251
社区成员
发帖
与我相关
我的任务
分享
header("Content-type:text/html;charset=utf8");
$a =array(array('id'=>'1','level'=>'1','name'=>'zhangsan','tuijianren'=>'2'),
array('id'=>'2','level'=>'2','name'=>'lisi','tuijianren'=>'3')
);
foreach($a as $v){
echo $v['id'];
foreach($a as $vv){
if($v['tuijianren'] ==$vv['id']){
echo '的推荐人等级是'.$vv['level'];
}
}
echo '<br>';
}
select a.guid,a.name,a.level,a.tuijianren,b.level from a LEFT JOIN (select name,level from a)as b on a.tuijianren = b.name;
select a.guid,a.name,a.level,a.tuijianren,b.level from a LEFT JOIN (select name,level from a)as b on a.tuijianren = b.name;
//没用过thinkphp,但是可用用SQL
select a.guid,a.name,a.level,a.tuijianren,b.level as tuijianrenlevel from 表名 a,表名 b where a.tuijianren = b.name;