case when null evaluates to false

Use something like

case when p.parent_id is null then false else true end as has_parent