newb question, how do I have a checkbox write data to my sql database

I would like to know how to have a checkbox send a 1 value to mysql database, or if checkbox is not ticked to keep entry NULL or 0

 <div class="form-group">
        <div class="custom-control creator-checkbox">
            <div class="">
                <input class="creator-control-input @error('terms') is-invalid @enderror" id="creator" type="checkbox" name="creator" value="1" placeholder="{{ __('creator') }}">
                <label class="creator-control-label" for="tosAgree">
                    <span>{{ __('Sign up as a content creator') }}</a>.</span>
                </label>
            </div>
        </div>
    </div>

this creates the field on the registration page but I dont know how to get it to put the info into mysql