I got the blank value from db in laravel on select

See more:

PHP

MySQL

database

QueryInterface

Hello guys i am facing a problem that i want to get start_date from database but i get only null values its not showing values

please check this image for better understanding https://imgur.com/eCrGeTW here is the code

What I have tried:

$data = \DB::table("subscriptions")
->select("subscriptions.*",
\DB::raw("(SELECT subscriptions.start_date FROM subscriptions
WHERE subscriptions.business_id = $business_id
) as date"))
->orderBy('subscriptions.start_date', 'desc')
->get();
dd($data);