Cancer is associated the most with children and Leo I would say comes in as number 2 in that aspect. Gemini can really relate to kids because of their youthfulness. Virgo, Pisces, and Libra all have soft spots for anything that seems innocent and defenseless so animals and children or I guess helpless adults? Scorpio might have a soft spot for them. Taurus is neutral.
Aries has energy and enthusiasm but might not know how to really act around children or how to treat them.
Capricorn makes for a good parent when they have kids but before that they might actually be a little rigid around them or not ever think about them/have a soft spot for them.
Aquarius and Sagittarius might be a bit out of touch with children too.