获取两个表差集

取两表交集

$map['b.field'] = array('exp', 'is not null');

取两表差值

$map['b.field'] = array('exp', 'is null');

$data = M('a')
  ->join('b ON b.id = a.id')
  ->where($map)
  ->select();