SELECT * FROM parent_table
LEFT JOIN child_tab ON parent_table.id = child_tab.parent_id
LEFT JOIN child_tab2 ON parent_table.id = child_tab2.parent_id

Where clause for that

WHERE COALESCE(child_tab.parent_id, child_tab2.parent_id) IS NOT NULL