Display data from two table by wpdb

i have two table tableA and tableB
the id field is unique (PK)

tableA
=====
id user_name
1 harun
2 mamun
3 titu
4 jaker
5 litu

tableB
====
id amount
1 5200
3 2000

i have made a query with $wpdb

“SELECT tableA.id,tableA.user_name,tableB.id,tableB.amount
WHERE tableA.id=tableB.id”

for this query i found the result
id user_name amount
1 harun 5200
3 titu 2000

but i wanna like as( all id will show but where in tableA amount not available it’ll show “no amount”)
id user_name amount
1 harun 5200
2 mamun no amount
3 titu 2000
4 jaker no amount
5 litu no amount

please help me anybody