在laravel 5.5中一次将数据插入多个表时，无法将类stdClass的对象转换为字符串

Question

$user_id   = $request->get('user_id');
            $email     = $request->get('email');
            $course_id = $request->get('course_id');

            $received_by = DB::table('affiliate_users')
                            ->select('first_upline_id','second_upline_id','third_upline_id')
                            ->where('user_id', '=', $user_id)
                            ->first();
          // dd($received_by);

           $a = DB::table('affiliate_income')->insert(
                       ['sent_by' => $user_id, 'course_id' => $course_id, 'received_by' => $received_by, ]
                );

           dd($a);

I want to insert data to multiple tables at a time. This is my controller's code. $received_by giving me selected values, without $received_by my $a is fine, but when using $received_by, I am getting this error.It should insert data to 'affiliate_users' three rows within same user_id.What should be the right query.Please someone help me. Here is my table bellow-

Answer 1

Assuming you have a column named as received_by in your table and you are here storing received_by id then

$user_id   = $request->get('user_id');
            $email     = $request->get('email');
            $course_id = $request->get('course_id');

            $received_by = DB::table('affiliate_users')
                            ->select('first_upline_id','second_upline_id','third_upline_id')
                            ->where('user_id', '=', $user_id)
                            ->first();
          // dd($received_by);

           $a = DB::table('affiliate_income')
->insert(['sent_by' => $user_id, 'course_id' => $course_id, 'received_by' => $received_by->received_by
//(or whatever you have to insert from $received_by object), 
                ]);

           dd($a);