Get User IDs with no boolean true answer
You can just map false/true to 0/1 and sum those per user. Those that have a zero sum have all false.

select userid 
from T
group by userid
having sum(case when active then 1 else 0 end) = 0;


A bit shorter is to use count instead of sum. Nulls are not counted, so we only need to map true to a value, and count all values. I use 1 here but you can pick any value that you want:

select userid 
from T
group by userid
having count(case when active then 1 end) = 0;