Single query SELECT propagate to childs

i have this table structure:

id
name
email
child_id <- pointing to id from "child" table

how SELECT this table data and propagate select to all childs with a SINGLE QUERY?