Remove 2 brackets after values
The wrong one is
INSERT INTO `users`(`id`, `userid`, `password`) VALUES ( (10, 'aa', 'abc'), (11, 'bb', 'abc'), (12, 'cc', 'abc') )
To insert more values with Python use for loop
https://stackoverflow.com/questions/14011160/how-to-use-python-mysqldb-to-insert-many-rows-at-once