thinkphp Multi-table query two tables have the perfect solution to duplicate the same field

Here is a thinkphp multi-table query two tables with duplicate the same field of the perfect solution. Content is very good, now share to everyone, but also for everyone to make a reference.

Frame: thinkphp

Version: 3.2.3

Content: Query statements

Resolve issue: repeating field issues

$Data = M (' a ')->where ($where)  ->field (' A.name as aname,b.name as Uname,a.* ')  ->join (' B on b.jb_id= a.ID ')  ->order (' a.id desc ')  ->select ();

Explanation:a.* queries all the fields in table A

A.name as Aname converts the name repeating field in table A to Aname