两列上的多个条件与order by

I have 3 tables

我有3张桌子

Users (Table1)
---------------------------
id      username    enabled
1       user1           1
2       user2           1
3       user3           1
4       user4           1

Packages (Table2)
---------------------------
id      package_type
1       lead
2       featured

Subscription (Table3)
---------------------------
id      user_id     package_id      enabled
1           1           1               1
2           1           2               1
3           2           1               0  <- user2 don't have lead package active
4           2           2               1
5           3           1               1
6           4           1               1
7           4           2               1
Users (Table1)
-----