Hongtting

use Illuminate\Support\Facades\DB;

 $test = DB::table(“test1_table”)

        -> select(“test1_table.*”, 

        DB::raw(” (select test2_table.name from test2_table where test1_table.id = test2_table.test1_id) as test2_name “)

        )

        ->get();