Laravel 5.4 将json保存到数据库

帮我将 json 保存到数据库。表字段类型 - 文本。 我有带有强制转换数组的模型

class Salesteam extends Model 
{
    protected $casts = [        
        'team_members' => 'array'
    ];
}

我想要像这样 {"index":"userId"} 获取 json 并将其存储到 db. 例子：

{"1":"7","2":"14","3":"25","4":"11"}

我在数据库中有 Salesteam 模型和“team_members”列，用于保存属于该团队的所有用户 ID。 我的代码通过 id 查找团队，获取所有“team_members”属性并将新用户添加到该团队。我想以 json 格式存储所有用户，并在添加新用户 ID 时增加索引。

销售团队属性：

"id" => 20
"salesteam" => "Admin"
"team_leader" => 0
"invoice_target" => 884.0
"invoice_forecast" => 235.0
"team_members" => "[1,66,71]"
"leads" => 0
"quotations" => 0
"opportunities" => 0
"notes" => ""
"user_id" => 1
"created_at" => "2017-09-22 09:13:33"
"updated_at" => "2017-09-22 13:10:25"
"deleted_at" => null

将新用户添加到团队的代码：

$salesTeam = $this->model->find($salesTeamId);
$teamMembers = $salesTeam->team_members;
$teamMembers[] = $userId;
$salesTeam->team_members = $teamMembers;
$salesTeam->save();

但它存储到数据库数组并且没有索引

"team_members" => "[1,34,56]"

来自 Laravel 文档 -数组和 JSON 转换 https://laravel.com/docs/5.4/eloquent-mutators“数组将自动序列化回 JSON 进行存储”

我哪里错了？

制作这样的 json 字符串

{"1":"7","2":"14","3":"25","4":"11"}

In php，当您将元素推入数组时，您必须传递一个键。例如

$teamMembers = [];
$teamMembers['1'] = 7;
$teamMembers['2'] = 14;
...

如果你不把它变成associative array, php转换为 json 字符串时会将其视为 json 数组..

Tip:你可以只传递一把钥匙，它也能起作用。 例如

$test = [1, 2, 3, 4, 5, 6];

$test['10'] = 56;

echo json_encode($test);

Output:

"{"0":1,"1":2,"2":3,"3":4,"4":5,"5":6,"10":56}"

PHP 参考 http://php.net/manual/en/function.json-encode.php#refsect1-function.json-encode-notes