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.
replyI've thought about this as well, but I think it's too troublesome so I don't want to do it. Just think of a function and do it. But I found a solution to replace it, which is to use tp's getter.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Either modify Mysql, or use foreach to judge with PHP