SQL : Self Join to query parent name

QueryParent.sql

-- Creating Table 
CREATE TABLE CensusPeople (
	id serial primary key,
	name varchar,
	parent_id int
);

-- Inserting Data
INSERT INTO CensusPeople (id, name, parent_id) 
VALUES 		(1, 'Zaki', 2),
			    (2, 'Ilham', NULL),
			    (3, 'Irwan', 2),
			    (4, 'Arka', 3);
          
-- Query
SELECT 		children.id AS id, 
			    children.name AS name,
			    parent.name AS parent_name 
FROM 		  CensusPeople AS children
LEFT JOIN	CensusPeople AS parent
ON			  parent.id = children.parent_id;