test/app/Http/Models/HootsuiteUser.php

<?php

namespace App\Http\Models;


use Illuminate\Database\Eloquent\Model;

class  HootsuiteUser extends Model
{
    protected $table = 'hootsuite_user';
    protected $guarded = [];

    public $casts = [
        'social_profiles' => 'array'
    ];

    public function site()
    {
        return $this->hasOne(Site::class,'id','site_id')->select(['cn_title','id']);
    }
}