You need to set !== to set an exact match since 0 would = false otherwise and never be true here

Site.php

    public function getActiveAttribute($value)
    {
        if($this->site_override()->first() != null && ($this->site_override()->first()->active !== null))
        {
            return $this->site_override()->first()->active;
        }
        return $value;
    }