sql server - SQL select -one to many joins want to have the manys -

i have 2 tables, tbl_parent (parentid, parentname) , tbl_children (parentid,child_name) parent can have 0 many children

what want query give me list of parent , children in single row per parent.

for example

parent1 john,mary  parent2 jane,steve,jana

and number of rows total number of parents

here answer need. not accepted answer question, right answer.

Detect