laravel - in sql the following query is given my desired output but in laravel model how can I retrieve it?

Question

sql query is

select *,sum(diposit_amount) as total from `diposits` group by `member_id`;

I am trying in model like this way

App\diposit::groupBy('member_id')
->selectRaw('*,sum(diposit_amount) as total')
->get();

but it gives errors "SQLSTATE[42000]: Syntax error or access violation: 1055 'pos.diposits.id' isn't in GROUP BY (SQL: select *,sum(diposit_amount) as total from diposits group by member_id) (View: C:\xampp\htdocs\pos\resources\views\welcome.blade.php) "

标签： laravel