want help in sql....

[ashishashish]

I have a application lyk that

A
/\
b c
/\ /\
d e f g......​

and like that so mean i have a parent node and each parents node has maximum two children nodes ,,,,,

SO I WANT A RECURSIVE FUNCTION TO COUNT THE NUMBER OF RECORDS OR U CAN SAY THE CHILD NODE OF THE DESIRED NODE(IN THIS CASE PARENT NODE)....WITH THE SQL STORE PROCEDURE.....
So any HELP ME IN THIS......