我有一张table叫 journal_details 它有一列名为 transaction_by_to . 我在存钱 account_head_id 值为 json_encode 格式 transaction_by_to 在表中 journal_details . 现在我想运行一个select查询，从中获取帐户头名称 account_heads 哪里 transaction_by_to json格式的id将从 account_heads . 在控制器中，我尝试了类似于bellow的东西，但只得到一个。但我想展示一下 account_heads 对于所有json格式的ID。

public function ledgerSubmit(Request $request)
{
    $acId       = $request->acount_head;
    $startDate  = Carbon::parse($request->start_date)->format('Y-m-d');
    $endDate    = Carbon::parse($request->end_date)->format('Y-m-d');
    $reportType = $request->report_type;
    $nameOfAccount = AccountHead::find($acId);
            $ledgers = DB::table('journal_details')
                    ->join('journals', 'journal_details.journal_id', '=', 'journals.id')
                    ->join('account_heads', 'journal_details.account_head_id', '=', 'account_heads.id')
                    ->where('journal_details.account_head_id', $acId)
                    ->select('journals.number as journalNo', 'journals.journal_date as journalDate', 'journal_details.*', 'account_heads.name as nameOfAccount')
                    ->get();
    if (count($ledgers)) {
            $transactionByToId = $ledgers[0]->transaction_by_to;
            foreach (json_decode($transactionByToId) as $tId) {
                $transactionByTo = AccountHead::where('id', $tId)->get();
            }
    }
return view('report.ledger.searched-result', compact('reportType', 'startDate', 'endDate', 'ledgers', 'transactionByTo', 'nameOfAccount'));
}

在刀片视图中-

@foreach($ledgers as $ledger)
        <tr>
            <td>{{ $loop->index + 1 }}</td>
            <td>{{ $ledger->journalNo }}</td>
            <td>{{ date('jS F, Y', strtotime($ledger->journalDate)) }}</td>
            <td>{{ $ledger->nameOfAccount }}</td>
            <td>
                {{ $transactionByTo[0]->name }}
            </td>
            <td>
                {{ number_format($ledger->debit, 2,".",",") }}
            </td>
            <td>
                {{ number_format($ledger->credit, 2,".",",") }}
            </td>
        </tr>
@endforeach
``` `["16","17","7","11"]` 是 `transaction_by_to` json格式的列值 `journal_details` 这些身份证是 `id` 为了 `account_heads` table。