在sql select语句中生成数字

I have a query that returns some parent records and child records. I would like to return for each child records a unique id by increment. So if i have a record with 3 childs and 1 with 2 childs would like to return.I have a query that returns some parent records