mysql> SELECT p2.DbId, p2.happiness, p2.user_DbId FROM `pet` AS p1 JOIN pet AS p2 ON ( p1.user_DbId = p2.user_DbId ) WHERE p2.user_DbId =142; +------+-----------+-----------+ | DbId | happiness | user_DbId | +------+-----------+-----------+ | 482 | 0 | 142 | | 484 | 0 | 142 | | 482 | 0 | 142 | | 484 | 0 | 142 | +------+-----------+-----------+ 4 rows in set (0.00 sec)