一张表中两个字段互相关联

  SELECT     t2.domid,    t2.chncode    FROM     `tb_device` as t1,    `tb_device` as t2    WHERE t1.device_code = t2.pid    AND t1.chncode = #{chncode}