Require MySQL Query for following situation [on hold]

I have a table like this:

<h3>id -- mem_id--amount--mode--dt</h3>
1 -- 1001-- 10-- A-- 2019-08-12<br />
2 -- 1001-- 30 -- C -- 2019-08-12<br />
3 -- 1001-- 20 -- C -- 2019-08-12<br />
4 -- 1001-- 30 -- B -- 2019-08-12<br />
5 -- 1001-- 20 -- D -- 2019-08-12<br />

I want to get a output like this:

<h3>Date -- Member -- A -- B -- C -- D</h3>
2019-08-12 -- 1001 --  10 -- 30 -- 50 -- 20

I want this query in Laravel Eloquent (or) MySQL RAW format.

via Chebli Mohamed