Laravel login not working with quickstart guide for my own database

I have a web app in Laravel
I was following this guide I can login as long as I don’t try and do the Optional: Custom User Handling part of the guide, which I need for the app I’m writing as I need to access that table to do other tasks, I have the users table and all but whenever I try and log in I get the following error:
SQLSTATE[HY000]: General error: 1364 Field ‘sub’ doesn’t have a default value

When I tried and set the field to nullable it goes on but then I get the following error, user_id does not exist, in the logs, in Auth0 I see a successful login attempt just does not seem to want to insert it, not really sure why.