求tp 不用query的写法

Question

SELECT * from mysqapp_member_friend WHERE uid_a in (SELECT uid_b uid FROM mysqapp_member_friend WHERE uid_a=537 and iscircle=0 and blacklist='false' and delstate='false') and bancircle=0 and uid_b=537

Answer 1

$uidArray = M('mysqapp_member_friend')->field('uid_b,uid')->where(array('uid_a'=>537,'iscircle'=>0,'blacklist'=>'false','delstate'=>'false'))->select();
$map['uid_a'] = array('in',$uidArray);
$map['bancircle'] = 0;
$map['uid_b'] = 537;
$res = M('mysqapp_member_firend')->where($map)->select();