A man was targeted in a drive-by shooting by a moped rider yards from children leaving a nearby nursery, according to witnesses.