A Captain Underpants spin-off book has been taken off sale and children's author Dav Pilkey has apologised for its "harmful racial stereotypes and passively racist imagery".