MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table your_table (id int,name varchar(50),published int);
insert into your_table values(1,'john',1),
(7,'alex',0),
(1,'roco',0),
(4,'mika',0),
(16,'mika',1),
(8,'alif',1),
(8,'zack',1);
SELECT id
FROM t 
GROUP BY id 
HAVING SUM(published = 0) = 0
Table 'fiddle_XGPSUCUJYEMDESYNWJTC.t' doesn't exist

select  t.* from your_table t
where t.id not in (
                  select id from your_table t1
                  where t1.published=0
                 )


id
name
published


16
mika
1

8
alif
1

8
zack
1