I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’

Look up user_registered in your database and set a valid value. This should be a datetime type, as described in the WordPress Codex. Press CMD/CTRL + F and lookup user_registered to quickly navigate.