你好像想要 not exists :

select t.*
from t
where not exists (select 1 from t t2 where t2.id = t.id and t2.status = 'false');

你可以用 group by 与 having 条款如下

select *
  from tab
 where id in
 (
  select id
    from tab
   group by id
  having max(status)=min(status)
 ) 
   and status!='false'

rextester演示

在砾石坑太晚了，所以这只是为了过去。

DROP TABLE IF EXISTS BEDROCK;
CREATE TABLE BEDROCK (ID INT, NAME VARCHAR(100), EMAIL VARCHAR(100), `Status` VARCHAR(6));

INSERT INTO BEDROCK (ID, NAME, EMAIL, `Status`) VALUES
(1,'Fred','fred.flintstone@stone.age','True'),
(1,'Wilma','wilma.flintstone@stone.age','False'),
(2,'Barney','barney.rubble@stone.age','True'),
(2,'Betty','betty.rubble@stone.age','True'),
(3,'Pebbles','pebbles.flintstone@stone.age','False'),
(3,'Bamm-Bamm','bamm-bamm.rubble@stone.age','False'),
(5,'Dino','dino@stone.age','True');

SELECT *
FROM BEDROCK t1
WHERE `Status` = 'true'
AND NOT EXISTS
(
  SELECT 1
  FROM BEDROCK t2
  WHERE t2.`Status` = 'false'
    AND t2.ID = t1.ID
);

结果：

ID  NAME    EMAIL                   Status
--  ------  ----------------------- ------
2   Barney  barney.rubble@stone.age True
2   Betty   betty.rubble@stone.age  True
5   Dino    dino@stone.age          True