How to use ifNUll in tp5 framework

Question

I am using leftJoin to query two tables, but the value found in a field (pname) is null. So how do I use ifNUll to set default values ​​for these null fields in tp5? Please let me know.

Answer 1

Either modify Mysql, or use foreach to judge with PHP